RE: AW: [sqlite] VB6 question
Steve,
I works very similar to ADO. Except no Data Control
Ray
Steve O'Hara <[EMAIL PROTECTED]> wrote:
How does a C++ wrapper help someone using VB6?
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of RAY BORROR
Sent: 29 July 2005 05:22
To: sqlite-users@sqlite.org
Subject: Re: AW: [sqlite] VB6 question
I am using SQLite Plus sucessfully
Ray Borror
Gregory Letellier 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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
>
>
>
>
RE: AW: [sqlite] VB6 question
How does a C++ wrapper help someone using VB6?
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of RAY BORROR
Sent: 29 July 2005 05:22
To: sqlite-users@sqlite.org
Subject: Re: AW: [sqlite] VB6 question
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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
>
>
>
>
Re: AW: [sqlite] VB6 question
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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
>
>
>
>
RE: AW: [sqlite] VB6 question
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
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
>
>
>
>
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
RE: AW: [sqlite] VB6 question
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
>>
>>
>>
>>
>
>
>
>
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
AW: [sqlite] VB6 question
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
>
>
[sqlite] VB6 question
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
