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();