Re: [sqlite] SQLite and Windows 2k

[andy]

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
Boy did I make that harder than it needed to be.  Here is the easy way:
gcc -shared -mno-cygwin -o sqlite3.dll \
  -L/lib/mingw -lmsvcrt  *.o sqlite3.def
-Andy
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

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
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]

Re: [sqlite] SQLite and Windows 2k

[Chris Ulliott]

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
>I noticed the sqlite3.def was also missing sqlite3_changes, so I added
it too.
>Let me know if you have problems.
>-Andy

Re: [sqlite] SQLite and Windows 2k

[Doug Currie]

>> the DLL does not export sqlite3_exec

> I noticed the sqlite3.def was also missing sqlite3_changes, so I added
> it too.

All the C functions listed in the capi3ref are now in the sqlite3.def
file in cvs.

e



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

Re: [sqlite] SQLite and Windows 2k

[andy]

Chris Ulliott wrote:
Hi All,
I have downloaded from the downloads page the DLL (Sqlite.dll) for
Windows. I have written some code using the API and everything was going
great until I needed to do an execute and it came to my attention that
the DLL does not export sqlite3_exec
Does anybody have a Win32 DLL of SQLite 3 that exports all the
documented functions? Am I missing something else?
I also tried using the SQLite3.dll instead but I soon found that there
are NO EXPORTED FUNCTIONS from there whatsoever.
Any help appreciated,
Thanks,
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
I noticed the sqlite3.def was also missing sqlite3_changes, so I added 
it too.

Let me know if you have problems.
-Andy
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite and Windows 2k

[Chris Ulliott]

Hi Richard
 
Unfortionatly there is no link for a Compiled Binary (win 32) for
version 2.x on the downloads page otherwise I would be using it.
 
Thanks for replying.
 
Chris
 
 
 
Richard Boehme wrote:
 
The regular sqlite.dll should be the 2.X release, not the 3 release, and
therefore won't export sqlite3_exec, but will export sqlite_exec.

As for the other, I haven't played around with sqlite3 much as I'm in
the middle of a project, but I intend to in a couple of days.


Thank you.

Richard Boehme




Chris Ulliott wrote: 

Hi All,

I have downloaded from the downloads page the DLL (Sqlite.dll) for

Windows. I have written some code using the API and everything was going

great until I needed to do an execute and it came to my attention that

the DLL does not export sqlite3_exec

Does anybody have a Win32 DLL of SQLite 3 that exports all the

documented functions? Am I missing something else?

I also tried using the SQLite3.dll instead but I soon found that there

are NO EXPORTED FUNCTIONS from there whatsoever.

Any help appreciated,

Thanks,

Chris




-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]






-

To unsubscribe, e-mail: [EMAIL PROTECTED]

For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite and Windows 2k

[andy]

Chris Ulliott wrote:
Hi All,
I have downloaded from the downloads page the DLL (Sqlite.dll) for
Windows. I have written some code using the API and everything was going
great until I needed to do an execute and it came to my attention that
the DLL does not export sqlite3_exec
Does anybody have a Win32 DLL of SQLite 3 that exports all the
documented functions? Am I missing something else?
I also tried using the SQLite3.dll instead but I soon found that there
are NO EXPORTED FUNCTIONS from there whatsoever.
Any help appreciated,
Thanks,
Chris
Hi Chris...  I had the exact same problem.  I am working on compiling my 
own dll (via cygwin)...  The dllwrap is winning right now, but I can run 
a combination of gcc and dlltool and create the library... however, it 
still seems to be requiring cygwin1.dll.

My PE-Explorer does show that everything is export thought, and I 
included sqlite3_exec (which was missing from sqlite3.def).  If I get it 
working I'll let you know.

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

Re: [sqlite] SQLite and Windows 2k

[Richard Boehme]

The regular sqlite.dll should be the 2.X release, not the 3 release, and 
therefore won't export sqlite3_exec, but will export sqlite_exec.

As for the other, I haven't played around with sqlite3 much as I'm in 
the middle of a project, but I intend to in a couple of days.

Thank you.
Richard Boehme

Chris Ulliott wrote:
Hi All,
I have downloaded from the downloads page the DLL (Sqlite.dll) for
Windows. I have written some code using the API and everything was going
great until I needed to do an execute and it came to my attention that
the DLL does not export sqlite3_exec
Does anybody have a Win32 DLL of SQLite 3 that exports all the
documented functions? Am I missing something else?
I also tried using the SQLite3.dll instead but I soon found that there
are NO EXPORTED FUNCTIONS from there whatsoever.
Any help appreciated,
Thanks,
Chris

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

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