Alexey Pechnikov wrote: > Original SQLite source tree has "ext " directory for extensions and I did > place my extensions into this directory > > $ ls sqlite3-3.6.20/ext > async billing compress empty env fts1 fts2 fts3 functions iconv icu > inet key md5 README.txt rtree tablefunc undo uuid versioning > virtualtext > > Ok! That's good to know. Now I understand better.
Based on your comments I reversed the changes to determine the essential ones. Here's the one that fit's with your corrections and works: Best. gcc -fPIC -lm -L../iconv/ -c -shared virtualtext.c -o libsqlitevirtualtext.so. The -c command is essential. Now I want to load the library. Spatialite doesn't cover loading the extension because it loads with the database. It starts with creating the Virtual Table. Here is what I tried and the errors: SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .load libsqlitevirtualtext.so (also tried 'libsqlitevirtualtext.so') Error: %1 ist keine zulässige Win32-Anwendung. Query: SELECT load_extension('libsqlitevirtualtext.so'); - executeStep failed Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) SQLiteManager: Query: select load_extension('libsqlitevirtualtext.so', 'auto_load'); - executeStep failed Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) Thanks for help to move me along- Gary Gabriel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users