Database Software

Greetings Everyone,

I have been creating just a test application of sorts to get use to working with various parts of the Oracle Lite ADO.Net libraries (v10.2.0.1.0) for the PocketPC. I am doing this in a standalone application so I do not need to deal with syncing with the server and what not (yet).

Currently the environment I am using for this is VS2003, PocketPC 2003 (Emulator), and Oracle Lite 10g. I have all the Oracle Lite components installed and working on the PocketPC 2003 Emulator.

According to the limited documentation on the Oracle Lite assemblies for .Net CF applications and ADO.Net, they talk about being able to create a database or remove a database by using the OracleEngine.CreateDatabase and OracleEngine.RemoveDatabase methods. I have been trying to get the CreateDatabase method to work. When I execute it as OracleEngine.CreateDatabase("Test", "Test", "") it seems to hang during the process of creating the database. The Emulator actually responds fine, but the CPU processing on my PC skyrockets to max usage. In the Emulator I can check the polite.ini file and see that the entries for the new database are created, yet the actual database file does not get created (Test.odb). If I launch Oracle's mSQL tool it will list the database (since it is in the polite.ini file), but obviously fails to connect to it since the physical file is not there.

I can create the database manually using the mSQL tool without a problem.

My goals for my little test app are to have it do the following:

1) Create and Remove a database.
2) Execute SQL to create database tables.
3) Execute SQL to populate tables with data.
4) Execute SQL to Query, Update, Delete data from the tables.

Everything I am doing works great other then the Create/RemoveDatabase methods. So, if anyone has any experience/tips in using them and getting them to work that would be great.

Thanks,

Dorian
Shadow Consulting