RE: [sqlite] [VC++ 6] Error compiling VBified source
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
> -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
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
--- 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] -