Re: [sqlite] Setting up SQLite for VB6

[J Trahair]

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 
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

Re: [sqlite] Setting up SQLite for VB6

[Bart Smissaert]

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 
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] Setting up SQLite for VB6

[J Trahair]

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