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