RE: [sqlite] [VC++ 6] Error compiling VBified source

2007-08-03 Thread Gilles Ganault

At 11:23 03/08/2007 -0700, Robert Simpson wrote:

Download the System.Data.SQLite.DLL I maintain from
http://sqlite.phxsoftware.com


Thanks, I'll check it out :-)

G.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] [VC++ 6] Error compiling VBified source

2007-08-03 Thread Robert Simpson
> -Original Message-
> From: Gilles Ganault [mailto:[EMAIL PROTECTED] 
> Sent: Friday, August 03, 2007 11:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] [VC++ 6] Error compiling VBified source
> 
> At 09:53 03/08/2007 -0700, Joe Wilson wrote:
> >This has come up before on the list. The instructions are wrong:
> 
> Sorry, should have thought someone had already tried.. and failed :-/
> 
> Browsing through the archives, it looks like the code might 
> not be 100% 
> reliable, so I'll probably look for another solution to have 
> an up-to-date 
> VB-compatible SQLite DLL.
> 

Download the System.Data.SQLite.DLL I maintain from
http://sqlite.phxsoftware.com

I've "wrapped" all the cdecl SQLite calls with corresponding stdcall
_interop calls and made minor adjustments to them for easier marshaling.
The library was designed to be used from .NET or straight C++, but you can
just as easily use it from VB6.  If using it from a non-dotnet language,
.NET runtimes are not required.  It doesn't statically link to them.

You could also download the source from there and compile just the primary
SQLite amalgamation with my modifications.  The interop.c file will have all
the declarations you need to write your imports in VB.

Robert



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] [VC++ 6] Error compiling VBified source

2007-08-03 Thread Gilles Ganault

At 09:53 03/08/2007 -0700, Joe Wilson wrote:

This has come up before on the list. The instructions are wrong:


Sorry, should have thought someone had already tried.. and failed :-/

Browsing through the archives, it looks like the code might not be 100% 
reliable, so I'll probably look for another solution to have an up-to-date 
VB-compatible SQLite DLL.


Thanks.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] [VC++ 6] Error compiling VBified source

2007-08-03 Thread Joe Wilson
--- Gilles Ganault <[EMAIL PROTECTED]> wrote:
>   As I'd like to be able to build my own SQLite DLL for use with Visual 
> Basic Classic, I followed Todd Tanner's instructions at 
> www.tannertech.net/sqlite3vb/ to make the (few) required changes and 
> compile with Visual C++ 6.0.

This has come up before on the list. The instructions are wrong:

 Comment out the following lines is loadext.c by adding 2 back slashes ("//") 
to the start of the
line. This prevents errors due to our changes.

 sqlite3_changes,
 sqlite3_close,

 sqlite3_last_insert_rowid,
 sqlite3_libversion,
 sqlite3_libversion_number,

 sqlite3_open,
 sqlite3_open16, 

Try to find another compatible sqlite3 driver.

> 
> As a test, after just making those changes in the amalgamated files, I get 
> an error:
> 
> //=sqlite3.h
> #include 
> #include 
> #include 
> #include 
> #include 
> 
> //sqlite_int64 sqlite3_last_insert_rowid(sqlite3*);
> sqlite_int64 __stdcall sqlite3_last_insert_rowid(sqlite3 *);
> 
> //=sqlite3.c
> //sqlite_int64 sqlite3_last_insert_rowid(sqlite3*);
> sqlite_int64 __stdcall sqlite3_last_insert_rowid(sqlite3*);
> 
> //=Compiling
> => sqlite3_last_insert_rowid,
> error C2152: 'initializing' : pointers to functions with different attributes
> 
> Is it a configuration issue? Actually, I didn't find where in VC++ 6.0 to 
> put the reference to the .DEF file (nothing that looks like Module 
> Definiont File under Linker.)



   

Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-