What's the correct (sanctioned by sub) way to open the DB?

[DronnyBoyd]

I tried using DatabaseHelperFactory to get the connection string, and then create an OleDbConnection, but it fails because the string has no "Provider=" in it. I don't know what the Provider string should be.

I tried using DatabaseHelperFactory.getDbProviderFactory().CreateConnection() but the connection fails when I call Open() on it, with

SystemException: Data Source cannot be empty. Use :memory: to open an in-memory database

So how exactly do I open the database? I know there are various example code fragments in the forum that refer to SQLite classes directly but that seems a bit hacky -- what's the *right* way to do it?

cheers

Dronny

[sub]

I prefer people dont access the database directly, but you should be able to do:

Code:

connection = DatabaseHelperFactory.getDbProviderFactory().CreateConnection();
connection.ConnectionString = DatabaseHelperFactory.getDbProviderFactory().getDbConnectionString();
connection.Open();

The golden rule though is 'dont create any tables, or modify the structure of any existing table in the database'.

[DronnyBoyd]

I prefer people dont access the database directly, but you should be able to do:

Code:

connection = DatabaseHelperFactory.getDbProviderFactory().CreateConnection();
connection.ConnectionString = DatabaseHelperFactory.getDbProviderFactory().getDbConnectionString();
connection.Open();

The golden rule though is 'dont create any tables, or modify the structure of any existing table in the database'.

Hah! Sorry for being so dumb, of course I didn't realise I had to add the connection string to the connection object, databases really aren't my thing.

Don't worry I won't add any tables to the DB, if I need one I'll create my own database (which I understand is quite simple using SQLite) and do it that way.

Thanks for the prompt response! (what time was it in NZ??)

Dronny

[sub]

what time was it in NZ??

I'd rather not say :o (far too early)