I am using SQLite Plus sucessfully Ray Borror Gregory Letellier <[EMAIL PROTECTED]> wrote: 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 >>> >>> >>> >>> >>> >>> >> >> >> >> > > > > > > >