Attached (now in the WIKI) is a VB6 wrapper that is a bit different to most in that it binds to the sqlite DLL at runtime.
Consequently, all you need to do is put this in your path along with the sqlite3.dll (or sqlite.dll if you want to use 2.8.x) and it sorts out the calls at runtime. The DLL also contains a Java JNI implementation that does the same thing. As with the VB6, you can call it from Java without having to worry about re-creating the DLL for each new release of sqlite. The zip contains VB6 and Java examples. As with sqlite, it's free and if you want the source code for the DLL I'll send it anyone that's interested. Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Gregory Letellier Sent: 28 July 2005 13:02 To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] VB6 question all the wrapper ar for 2.8 and i wan't use the 3.0 anyone known 3.0 wrapper ? Steve O'Hara a écrit : >Don't want to dampen your enthusiasm for this route but..... why do you >think there are so many VB wrappers for SQLite? > >It's because you can't use the SQLite DLL directly from VB - some functions >will work but the essential ones won't. It's because the DLL returns things >like pointers to arrays of pointers which is not very groovy in VB (in fact, >you would have to resort to some OS calls to unravel that). > >Use one of the wrappers. > >Steve > > > > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] >rg]On Behalf Of Gregory Letellier >Sent: 27 July 2005 11:17 >To: sqlite-users@sqlite.org >Subject: Re: AW: [sqlite] VB6 question > > >Ok Thank's for your help i will trying this !!! > >[EMAIL PROTECTED] a écrit : > > > >>Hi, >> >>unfortunately this has to do with the C calling convention used by >> >> >sqlite3.dll. By default DLLs compiled with C have the cdecl calling >convention, but VB only supports the stdcall calling convention. > > >>You must recompile sqlite using MS Visual C++ or other compiler and switch >> >> >the default calling convention from cdecl to stdcall in the compiler/linker >settings. > > >>HTH >>Michael >> >> >> >> >> >>>hello i'm trying to open a database with VB6 without wrapper >>> >>>i'm using sqlite3.dll >>> >>>and it's my code : >>> >>>Option Explicit >>>Private Declare Function sqlite3_open Lib "sqlite3.dll" (ByVal filename >>>As String, ByRef dbHandle As Long) As Long >>>Private Declare Function sqlite3_open16 Lib "sqlite3.dll" (ByVal >>>filename As String, ByRef dbHandle As Long) As Long >>>Private Declare Sub sqlite3_close Lib "sqlite3.dll" (ByVal DB_Handle As >>>Long) >>> >>>Private Sub Form_Load() >>> Dim lRet As Long >>> Dim lDbHandle As Long >>> Dim sFilename As String >>> >>> sFilename = "c:\toto.db" >>> sqlite3_open sFilename, lDbHandle >>> MsgBox ("lRet=" & lRet) >>> MsgBox ("ldbhandle=" & lDbHandle) >>> sqlite3_close (lDbHandle) >>>End Sub >>> >>>when i launch it, i've an error 49 : Bad DLL calling convention >>> >>>anyone can help me ? where is my fault ? >>> >>>thx >>>Gregory Letellier >>> >>> >>> >>> >>> >>> >> >> >> >> > > > > > > >