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]

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


Reply via email to