[pysqlite] Compiled apsw on windows with no errors but it doesnt work

Stuart <[email protected]> Thu, 09 Jul 2009 08:17:39 +1000
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
I downloaded the latest version of apsw for python.  I used setup.py 
install (I had previously done a --fetch.sqlite to get the latest 
version of sqlite.)  It seemed to compile OK (see output below) with 
warnings but no errors. It seems to install OK but it wont load.

I have no idea where to look for a fix.  Any ideas would be gratefully 
accepted.

Thanks

Stuart Galloway

I am using binary python 2.6.2 on with vista business.

-------------------------------------------------------------------



C:\Users\sg\Desktop\frank\apsw-3.6.16-r1>c:\python26\python setup.py 
install --enable=fts3
SQLite: Using amalgamation 
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c
running install
running build
running build_ext
building 'apsw' extension
C:\PortableApps\PortableApps\MinGWPortable\App\MinGW\bin\gcc.exe 
-mno-cygwin -mdll -O -Wall -DEXPERIMENTAL=1 -DSQLITE_ENABLE_FTS3=1 
-DNDEBUG=1 -DAPSW_
In file included from src/apsw.c:61:
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c: In function 
`getNextString':
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:100849: warning: 
'zNew' might be used uninitialized in this function
src/apsw.c: At top level:
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:91100: warning: 
'sqlite3_db_config' defined but not used
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:3220: warning: 
'sqlite3_column_database_name' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:3221: warning: 
'sqlite3_column_database_name16' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:3222: warning: 
'sqlite3_column_table_name' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:3223: warning: 
'sqlite3_column_table_name16' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:3224: warning: 
'sqlite3_column_origin_name' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:3225: warning: 
'sqlite3_column_origin_name16' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:92540: warning: 
'sqlite3_global_recover' defined but not used
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:15434: warning: 
'sqlite3_memory_alarm' defined but not used
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:4162: warning: 
'sqlite3_key' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:4175: warning: 
'sqlite3_rekey' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:4541: warning: 
'sqlite3_table_column_metadata' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:73006: warning: 
'sqlite3_auto_extension' defined but not used
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:5365: warning: 
'sqlite3_mutex_held' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:5366: warning: 
'sqlite3_mutex_notheld' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:10662: warning: 
'sqlite3_db_status' defined but not used
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:50244: warning: 
'sqlite3_stmt_status' defined but not used
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:6129: warning: 
'sqlite3_unlock_notify' declared `static' but never defined
C:\Users\sg\Desktop\frank\apsw-3.6.16-r1\sqlite3.c:100532: warning: 
'sqlite3Fts3IcuTokenizerModule' declared `static' but never defined
writing build\temp.win32-2.6\Release\src\apsw.def
C:\PortableApps\PortableApps\MinGWPortable\App\MinGW\bin\gcc.exe 
-mno-cygwin -shared -s build\temp.win32-2.6\Release\src\apsw.o 
build\temp.win32-2.6\R
running install_lib
copying build\lib.win32-2.6\apsw.pyd -> c:\python26\Lib\site-packages
running install_egg_info
Removing c:\python26\Lib\site-packages\apsw-3.6.16_r1-py2.6.egg-info
Writing c:\python26\Lib\site-packages\apsw-3.6.16_r1-py2.6.egg-info

C:\Users\sg\Desktop\frank\apsw-3.6.16-r1>python
Python 2.6.2 (r262:71605, Apr 14 2009, 22:40:02) [MSC v.1500 32 bit 
(Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
 >>> import apsw
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: DLL load failed: The specified procedure could not be found.
 >>>