Thank you, it's working now. Regards
Jonathan On 21/11/2016 09:19, Bart Smissaert wrote:
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
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
