[Mono-dev] System.Data.SQLite under mono

[Arne Claassen]

Jonathan,

thanks for the pointers. For some reason the MONO_LOG_* stuff didn't  
show me which lib was being loaded, always listed it as ./ 
libsqlite3.so.0 instead of the real path. However doing a locate i  
noticed that i had a copy in /usr/lib and the new one i built was in / 
usr/local/lib, so it kept finding the first. nm -D was the one that  
showed that it found a lib, just not that export and running it  
against the /usr/local copy it did find the right one, so i just had  
to install the new one in the right place. Now it all works

Arne Claassen

MindTouch
San Diego, CA
http://twitter.com/sdether

On May 12, 2009, at 8:17 AM, Jonathan Pryor wrote:

> On Mon, 2009-05-11 at 23:08 -0700, Arne Claassen wrote:
>> I'm trying to get phxsoftware's System.Data.SQLite managed-only dll
>> working under mono. The readme claims i should just need the binary  
>> in
>> the same directory and it works for mono. It does work for windows, i
>> just drop sqlite3.dll in the dir and it works. However, i try the  
>> same
>> with sqlite3.so and i get the following on opening the connection:
>
> It should be libsqlite3.so, not sqlite3.so.
>
> You should also try running with the MONO_LOG_LEVEL and MONO_LOG_MASK
> environment variables exported to view additional diagnostic
> information:
>
> 	MONO_LOG_LEVEL=info MONO_LOG_MASK=dll mono yourapp.exe
>
> This will allow you to determine if libsqlite3.so is actually being
> found (and if so, which one is being found).
>
> You may also check to see that sqlite3_next_stmt is exported from your
> libsqlite3.so file:
>
> 	nm -D /path/to/libsqlite3.so | grep sqlite3_next_stmt
>
> - Jon
>
>