That is because you are statically linking the SQLite shell and the SQLite library into a single executable file instead of having the shell (sqlite3.exe) and the library (sqlite3.dll?) in separate files.
-----Ursprüngliche Nachricht----- Von: Keith Christian [mailto:keith1christ...@gmail.com] Gesendet: Dienstag, 11. März 2014 17:11 An: General Discussion of SQLite Database Betreff: Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin Richard, Thanks for the reply. Your instructions produced a working sqlite3.exe in the Cygwin environment, using sqlite-amalgamation-3080401.zip. The resulting file is quite large, almost 14 times the size of the sqlite3 version 3.8.3 packages with Cygwin: ls -l /usr/bin/sqlite3.exe -rwxr-xr-x 1 kchris0000 Domain Users 60957 Feb 4 04:45 /usr/bin/sqlite3.exe ls -l ./sqlite3.exe -rwxr-xr-x 1 kchris0000 Domain Users 845353 Mar 11 10:05 ./sqlite3.exe But it works! ./sqlite3.exe SQLite version 3.8.4.1 2014-03-11 15:27:36 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .quit Keith On Tue, Mar 11, 2014 at 8:30 AM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Mar 11, 2014 at 9:46 AM, Keith Christian > <keith1christ...@gmail.com>wrote: > >> A few days ago, I successfully compiled the previous version of the >> autoconf tar package (sqlite-autoconf-3080300.tar.gz) and a >> sqlite3.exe file was produced on a Cygwin environment. >> >> This morning, I downloaded sqlite-autoconf-3080400.tar.gz, unpacked, >> ran 'make clean' and 'make', but no sqlite3.exe file was produced. >> > > > I'm sorry you are having trouble. > > I don't know what is wrong because everything works fine when I try it. > > As an alternative, consider downloading > sqlite-amalgamation-3080400.zip and then running: > > gcc -o sqlite3.exe -I. sqlite3.c shell.c > > > > > >> >> I believe the issue is in some changes in the Makefiles produced >> between 3080300 and 3080400. >> >> Makefile.am and Makefile.in are identical between 3080300 and 3080400. >> >> The cygwin environment on the machine has not been updated since >> 3080300 was compiled on 7 Mar. >> >> See the output of 'wdiff' below. Recent versions of the VIM editor >> have a nice syntax mode for wdiff, copy the output below into VIM and >> then type "syn on" and "set filetype=wdiff" at the colon prompt. >> >> >> >> wdiff -s ../../sqlite-autoconf-3080300/tea/Makefile >> ../../sqlite-autoconf-3080400/tea/Makefile|grep "\[-.*-\]"|sed 'G;G' >> >> >> PKG_LIB_FILE = [-libsqlite3.8.3.dll-] {+libsqlite3.8.4.dll+} >> >> >> PKG_STUB_LIB_FILE = [-libsqlitestub3.8.3.a-] {+libsqlitestub3.8.4.a+} >> >> >> INSTALL = [-/usr/bin/install-] {+$(SHELL) >> $(srcdir)/tclconfig/install-sh+} -c >> >> >> PACKAGE_VERSION = [-3.8.3-] {+3.8.4+} >> >> >> #DEFS = $(TCL_DEFS) -DPACKAGE_NAME=\"sqlite\" >> -DPACKAGE_TARNAME=\"sqlite\" [--DPACKAGE_VERSION=\"3.8.3\"-] >> {+-DPACKAGE_VERSION=\"3.8.4\"+} -DPACKAGE_STRING=\"sqlite\ >> [-3.8.3\"-] {+3.8.4\"+} -DPACKAGE_BUGREPORT=\"\" -DPACKAGE_URL=\"\" >> {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 >> -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 >> -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 >> -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1 >> -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1 >> -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1 >> -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1 >> -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long >> -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 >> $(PKG_CFLAGS) >> >> >> DEFS = -DPACKAGE_NAME=\"sqlite\" >> -DPACKAGE_TARNAME=\"sqlite\" [--DPACKAGE_VERSION=\"3.8.3\"-] >> {+-DPACKAGE_VERSION=\"3.8.4\"+} -DPACKAGE_STRING=\"sqlite\ >> [-3.8.3\"-] {+3.8.4\"+} -DPACKAGE_BUGREPORT=\"\" -DPACKAGE_URL=\"\" >> {+-DBUILD_sqlite=/\*\*/+} -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 >> -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 >> -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 >> -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DNO_VALUES_H=1 -DHAVE_LIMITS_H=1 >> -DHAVE_SYS_PARAM_H=1 -DUSE_SYSTEM_SQLITE=1 -DUSE_THREAD_ALLOC=1 >> -D_REENTRANT=1 -D_THREAD_SAFE=1 -DTCL_THREADS=1 -DSQLITE_THREADSAFE=1 >> -DMODULE_SCOPE=extern [--DNO_VIZ=1-] {+-DHAVE_NO_SEH=1 >> -DHAVE_CAST_TO_UNION=1+} -DTCL_WIDE_INT_TYPE=long\ long >> -DUSE_TCL_STUBS=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 >> $(PKG_CFLAGS) >> >> >> >> Keith >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ----------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
