tags:

views:

93

answers:

0

I am attempting converting an application from VB6 to an iphone app.

In the VB version, the database is in Access. But, I have read that I need to convert it to SQLite.

How I amend the following code to switch from Access to SQLite?

cnList = new ADODB.Connection();
rsList = new ADODB.Recordset();
cnList.Provider = "Microsoft.Jet.OLEDB.4.0;";
cnList.ConnectionString = "Persist Security Info=False;"+CString("Data Source=cbe.mdb");
cnList.Open();