RE: [sqlite] Building for Windows
Thank you all for answer - it seems to be working now for some reason :-/ I just got the new source out today and tried rebuilding and it worked. The only thing I changed is that I install Tcl into my Cygwin, which I didn't have before... Anyway, the good thing is that the problem is solved :-) Regards, Dennis // Software for animal shelters http://www.smartpethealth.com // -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 1:08 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Building for Windows Dennis Volodomanov wrote: > > Is there any way to rebuild the SQLite v3 for Windows? It seems that > the makefiles that come with it are for *nix-based machines only :-( > Dennis, I use the MinGW/MSYS build environment to build under Win XP. It generate native Win32 libraries, DLL, and import libs for use with other compilers. You can download and install MinGW and MSYS from http://www.mingw.org/. You will need to install the tcl/tk package as well to run the test suite. My build process is almost exactly as described in the How To Compile wiki page http://www.sqlite.org/cvstrac/wiki?p=HowToCompile I create the build directory beside the sqlite directory obtained from CVS. CD into the build directory and run ../sqlite/configure to generate a Makefile in the build directory. Then run the following make commands. "make" to build libraries and sqlite.exe "make test" to build and run the sqlite test suite "make dll" to build windows DLL "make implib" to build import libraries to allow the DLL to be used with Borland and/or Microsoft compilers "make install" to install sqlite.exe into the MSYS environment It has worked flawlessly for me since about version 2.8.12 or so. Good luck.
Re: [sqlite] Building for Windows
Dennis Volodomanov wrote: > > Is there any way to rebuild the SQLite v3 for Windows? It seems that > the makefiles that come with it are for *nix-based machines only :-( > Dennis, I use the MinGW/MSYS build environment to build under Win XP. It generate native Win32 libraries, DLL, and import libs for use with other compilers. You can download and install MinGW and MSYS from http://www.mingw.org/. You will need to install the tcl/tk package as well to run the test suite. My build process is almost exactly as described in the How To Compile wiki page http://www.sqlite.org/cvstrac/wiki?p=HowToCompile I create the build directory beside the sqlite directory obtained from CVS. CD into the build directory and run ../sqlite/configure to generate a Makefile in the build directory. Then run the following make commands. "make" to build libraries and sqlite.exe "make test" to build and run the sqlite test suite "make dll" to build windows DLL "make implib" to build import libraries to allow the DLL to be used with Borland and/or Microsoft compilers "make install" to install sqlite.exe into the MSYS environment It has worked flawlessly for me since about version 2.8.12 or so. Good luck.
RE: [sqlite] Building for Windows
On Thu, 5 Aug 2004, Dennis Volodomanov wrote: >I'm sorry, but I just can't build it :-( I'm using CygWin and I've ran >the 'configure' command and then I type 'make' and this is what I get: > >$ make >./libtool --mode=compile gcc -g -O2 -DOS_WIN=1 -DHAVE_USLEEP=1 -I. >-I./src -DNDE >BUG -c ./src/build.c > gcc -g -O2 -DOS_WIN=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG -c >./src/build.c -D >PIC -o .libs/build.o >src/build.c: In function `sqlite3EndTable': >src/build.c:1401: error: `OP_ParseSchema' undeclared (first use in this >function >) >src/build.c:1401: error: (Each undeclared identifier is reported only >once >src/build.c:1401: error: for each function it appears in.) >src/build.c: In function `sqlite3DropTable': >src/build.c:1689: error: `OP_DropTable' undeclared (first use in this >function) >src/build.c: In function `sqlite3CreateIndex': >src/build.c:2159: error: `OP_ParseSchema' undeclared (first use in this >function >) >src/build.c: In function `sqlite3DropIndex': >src/build.c:2258: error: `OP_DropIndex' undeclared (first use in this >function) >make: *** [build.lo] Error 1 > >Does anyone have any ideas on how to do this or what is wrong? Is opcodes.h empty? Try removing it so it gets regenerated, and look for errors in regeneration of opcodes.h: $ rm opcodes.h $ make opcodes.h You may be missing some command required. If grep, sed or awk are missing, you'll get a broken pipeline when regenerating the file and be left with essentially an empty file. Christian -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
RE: [sqlite] Building for Windows
I'm sorry, but I just can't build it :-( I'm using CygWin and I've ran the 'configure' command and then I type 'make' and this is what I get: $ make ./libtool --mode=compile gcc -g -O2 -DOS_WIN=1 -DHAVE_USLEEP=1 -I. -I./src -DNDE BUG -c ./src/build.c gcc -g -O2 -DOS_WIN=1 -DHAVE_USLEEP=1 -I. -I./src -DNDEBUG -c ./src/build.c -D PIC -o .libs/build.o src/build.c: In function `sqlite3EndTable': src/build.c:1401: error: `OP_ParseSchema' undeclared (first use in this function ) src/build.c:1401: error: (Each undeclared identifier is reported only once src/build.c:1401: error: for each function it appears in.) src/build.c: In function `sqlite3DropTable': src/build.c:1689: error: `OP_DropTable' undeclared (first use in this function) src/build.c: In function `sqlite3CreateIndex': src/build.c:2159: error: `OP_ParseSchema' undeclared (first use in this function ) src/build.c: In function `sqlite3DropIndex': src/build.c:2258: error: `OP_DropIndex' undeclared (first use in this function) make: *** [build.lo] Error 1 Does anyone have any ideas on how to do this or what is wrong? Thanks! Dennis -Original Message- From: andy [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 August 2004 11:11 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Building for Windows Dennis Volodomanov wrote: > Hello all, > > Is there any way to rebuild the SQLite v3 for Windows? It seems that the > makefiles that come with it are for *nix-based machines only :-( > > For example, I just got the latest code from CVS, but it doesn't include > files such as opcodes.* and others and now I cannot build the library > successfully, because it reports (for example), that it can't find > OP_ParseSchema (along with some others). > > But, opcodes.* files are automatically generated and I cannot do that, > so could you please tell me how to make them or where to get them from? > > TIA > >Dennis What compiler are you using? There are pre-generated source files you can compile from. Or, if you wanna do the entire thing yourself, you can use cygwin. Personally, I use the Makefile.linux-gcc file, modify it a little to remove the tcl stuff, tack on "-mno-cygwin" and run make... -Andy
RE: [sqlite] Building for Windows
Yes, using Cygwin has slipped my mind :-) I will try that. Thanks! Dennis -Original Message- From: andy [mailto:[EMAIL PROTECTED] Sent: Thursday, 5 August 2004 11:11 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Building for Windows Dennis Volodomanov wrote: > Hello all, > > Is there any way to rebuild the SQLite v3 for Windows? It seems that the > makefiles that come with it are for *nix-based machines only :-( > > For example, I just got the latest code from CVS, but it doesn't include > files such as opcodes.* and others and now I cannot build the library > successfully, because it reports (for example), that it can't find > OP_ParseSchema (along with some others). > > But, opcodes.* files are automatically generated and I cannot do that, > so could you please tell me how to make them or where to get them from? > > TIA > >Dennis What compiler are you using? There are pre-generated source files you can compile from. Or, if you wanna do the entire thing yourself, you can use cygwin. Personally, I use the Makefile.linux-gcc file, modify it a little to remove the tcl stuff, tack on "-mno-cygwin" and run make... -Andy
Re: [sqlite] Building for Windows
Dennis Volodomanov wrote: Hello all, Is there any way to rebuild the SQLite v3 for Windows? It seems that the makefiles that come with it are for *nix-based machines only :-( For example, I just got the latest code from CVS, but it doesn't include files such as opcodes.* and others and now I cannot build the library successfully, because it reports (for example), that it can't find OP_ParseSchema (along with some others). But, opcodes.* files are automatically generated and I cannot do that, so could you please tell me how to make them or where to get them from? TIA Dennis What compiler are you using? There are pre-generated source files you can compile from. Or, if you wanna do the entire thing yourself, you can use cygwin. Personally, I use the Makefile.linux-gcc file, modify it a little to remove the tcl stuff, tack on "-mno-cygwin" and run make... -Andy