Hi all, I hope this is now the right place to tell this story after being redirected to this list by drh. I first submitted this as a ticket (sorry about that).
I am building sqlite from sources in a debian sarge box. I am interested in Loadable Extensions. I had to introduce into the Makefile the following lines to enable the loadable extension mechanism: TCC += -DHAVE_DLOPEN and TLIBS += /usr/lib/libdl.so And then I go, no problems building. I have sqlite built with this feature I guess. But the thing is that I cannot make it to work. I prepared a c file following the template given in the wiki. I generated a .so using: gcc -I/path_to_sqlite-3.3.7/src -c -o Extension.o Extension.c And gcc -shared -o Extension.so Extension.o /path_to_libsqlite3.so/libsqlite3.so I linked with this warning: /usr/bin/ld: Warning: size of symbol 'sqlite3_api' changed from 4 to 460 in /path_to_libsqlite3.so/libsqlite3.so But it produced the .so that I wanted. When I do in sqlite3 prompt: .load Extension.so It goes: unable to open shared library [Extension.so] Any clues of what is going on? Perhaps a sample gcc invokation line for building the extension would also be a good thing in the docs. Thank you very much. jima ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------