Re: [sqlite] Setting up SQLite for VB6

2016-11-21 Thread 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

Re: [sqlite] Setting up SQLite for VB6

2016-11-21 Thread 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

[sqlite] Setting up SQLite for VB6

2016-11-21 Thread 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