Re: [sqlite] SQLite and Windows 2k

[andy]

Chris Ulliott wrote:
Andy!
 
FANTASTIC JOB! Thank you! Could you also make the source available
please and tell me what changes you made? In the future if a new version
comes out, it may not include your change and I need it!
 
I would hate to upgrade and loose your change...
 
Thanks again, Great work!
 
Chris
 

Wahoo! Got it! It was a -mno-cygwin that was the magic. I have uploaded
it to my website. You can get it from
<http://squeakycode.net/files/sqlite3.dll>
http://squeakycode.net/files/sqlite3.dll
I noticed the sqlite3.def was also missing sqlite3_changes, so I added
it too.
Let me know if you have problems.
-Andy

I made no changes to the .c files.  the .def file has been patched and 
checked in so you wont need to edit it either.

So here is what I did.
dl the source and uncompress it.  then
mkdir build
cd build
../configure
Then I edited the Makefile and changed this line:
TCC = gcc -g -O2 -mno-cygwin -DOS_WIN=1 -DHAVE_USLEEP=1 -I. -I${TOP}/src
to include the -mno-cygwin
then do a make.  This will make the sqlite.exe for windows without 
requiring the cygwin1.dll

To make the dll, I could not get the dllwrap to work.  Based on:
http://www.neuro.gatech.edu/users/cwilson/cygutils/dll-stuff/README
I used this script to create the dll.
#!/bin/sh
gcc -mno-cygwin -Wl,--base-file,base.tmp \
 -mdll -Wl,-e,[EMAIL PROTECTED] \
  -o sqlite3.dll *.o -L/lib/mingw -lmsvcrt
dlltool --base-file base.tmp --output-exp exp.tmp --def sqlite3.def
gcc -mno-cygwin -Wl,--base-file,base.tmp  exp.tmp \
  -mdll -Wl,-e,[EMAIL PROTECTED] -o sqlite3.dll \
  *.o  -L/lib/mingw  -lmsvcrt
dlltool --base-file base.tmp --output-exp exp.tmp --def sqlite3.def
gcc exp.tmp -mno-cygwin -mdll \
  -Wl,-e,[EMAIL PROTECTED] -o sqlite3.dll \
  *.o -L/lib/mingw  -lmsvcrt
strip sqlite3.dll
cp sqlite3.dll /cygdrive/d/sqlite/
Watch the wrapping, I added a blank line between each command.
However, I dont really think you'll need all that.  Sense  3 is still in 
beta its probably just a build problem that'll get cleared up.  You'll 
be able to download the dll just fine and it'll work once all the kinks 
get worked out.  I'm just posting this so people can play with the dll 
while its in beta.

Have fun,
-Andy
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]