Make sure that you have all the necessary .h files in the same directory as the spellfix.c source code (the #include's use " " rather than < >, which means look in the current directory, not the include path).
Use the following command line in the directory containing source (.c) and header (.h) files: gcc -mdll -s spellfix.c -o spellfix.dll Notes: -mthreads is not necessary. static lib-gcc is not necessary. This will generate only dependancies on KERNEL32 and the MSVCRT.DLL subsystem runtime. If you want to use a specific (common) runtime, then you need to link that runtime. The long form might be required for some modules: gcc -mdll -mthreads -s -DSQLITE_API=__declspec(dllexport) -Wl,-Bstatic <sourcefile> -o <dllfile> -static-libgcc plus any special platform runtimes you want to use in preference to the subsystem runtime (such as msvcrt90 etc). --- Theory is when you know everything but nothing works. Practice is when everything works but no one knows why. Sometimes theory and practice are combined: nothing works and no one knows why. >-----Original Message----- >From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- >bounces at mailinglists.sqlite.org] On Behalf Of sonypsx >Sent: Thursday, 12 March, 2015 11:56 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] System.Data.SQLite and spellfix under VB.net > >Hello, > >may i ask again ... >Can somebody help to successfully compile spellfix.c for windows? >Errors see below! > >Cheers >sonypsx > >-----Urspr?ngliche Nachricht----- >Von: sqlite-users-bounces at mailinglists.sqlite.org >[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von >sonypsx >Gesendet: Mittwoch, 04. M?rz 2015 19:54 >An: 'General Discussion of SQLite Database' >Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net > >Hello Joe, > >ok i'll tried: > >gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c > >and got this error: > >c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\ -shared -o spellfix.dll >c:\Sqlite\ext \misc\spellfix.c In file included from >c:\Sqlite\ext\misc\spellfix.c:17:0: >c:\Sqlite\src/sqlite3ext.h:20:21: fatal error: sqlite3.h: No such file or >direct ory #include "sqlite3.h" > ^ >compilation terminated. > >c:\MinGW\bin> > >If I look into sqlite3ext.h i see the reference to the sqlite3.h file >which >does not exist in the whole sqlite source (zip) which I downloaded from >http://www.sqlite.org/src/info/e693e11d1b926597 > > >Can you help me please? > >Best regards >sonypsx > >-----Urspr?ngliche Nachricht----- >Von: sqlite-users-bounces at mailinglists.sqlite.org >[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Joe >Mistachkin >Gesendet: Montag, 02. M?rz 2015 22:37 >An: 'General Discussion of SQLite Database' >Betreff: Re: [sqlite] System.Data.SQLite and spellfix under VB.net > > >sonypsx wrote: >> >> could some please post a sample how to use the spellfix module with >> System.Data.SQLite under VB.net? >> > >The first step would be to compile the spellfix extension as a loadable >module, as documented here: > > https://www.sqlite.org/loadext.html > >Next, you can load it using the SQLiteConnection.LoadExtension method. > >Finally, you should be able to follow along with the normal spellfix >docs, >here: > > https://www.sqlite.org/spellfix1.html > >-- >Joe Mistachkin > >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
