Thanks for the advice but it would not work either. I just tried with the flags you mentioned at compile time and full path when loading.
Do you know if I have to enclose that full path in quotes or something at load time? like... .load '/path/Extension.so' ? I tried several combinations of quotes but no luck here. I will recheck all what I have been doing just to make sure there is not an easy explanation for this... Thanks again, jima 2006/9/15, Christian Werner <[EMAIL PROTECTED]>:
jima wrote: > ... > 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 Add the compiler switch -fPIC here. > And > > gcc -shared -o Extension.so Extension.o/path_to_libsqlite3.so/libsqlite3.so Omit libsqlite3.so here, there's no need for it in the extension. > ... > When I do in sqlite3 prompt: > > ..load Extension.so Use the full path to Extension.so or prefix it with ./ Hope that helps, Christian ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------