I think you will need this ODBC driver: http://www.ch-werner.de/sqliteodbc/
RBS On Mon, Nov 21, 2016 at 8:12 AM, J Trahair <j.trah...@foreversoftware.co.uk> wrote: > Hi everyone > > I am trying to link a VB6 project to SQLite. (I can do this fine in > VB.Net.) I am using System.Data.SQLite.dll file version 1.0.66.0, and the > following connection properties: > > Option Explicit > Public grsUtilities As ADODB.Recordset > Public gconn As ADODB.Connection > Public mstrSQL As String > > Private Sub Command1_Click() > > Set gconn = New ADODB.Connection > gconn.ConnectionString = "DRIVER=SQLite3 ODBC Driver;Database=C:\My > Documents\Access VideoOCR\My_database.db;Version=3;" > 'or > 'gconn.ConnectionString = "ODBC CONNECT TO [SQLite3 > Datasource;Database=C:\My Documents\Access VideoOCR\My_database.db;];" > > gconn.Open > > Set grsUtilities = New ADODB.Recordset > grsUtilities.CursorLocation = adUseServer > grsUtilities.Open mstrSQL, gconn, adOpenForwardOnly, adLockReadOnly > > End Sub > > I have set a reference to Microsoft ActiveX Data Objects 2.8 Library. > > The SQLite dll is in the folder C:\My Documents\Access VideoOCR along with > the database. > > The error message is: [Microsoft][ODBC Driver manager] Data source name > not found and no default driver specified (for both connection strings). > > Please can you let me know what I am missing. > > Thank you. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
