System.Data.SQLite

Hi, Has anyone tried to use the the managed version of the libraries in combination with mono? I'm running FreeBSD, with SQLite 3.6.2, and it fails most of the System.Data.SQLite tests. Any advice will be greatly appreciated. Fran

Did you get this sorted out?

If not, I'll need more details on how you compiled the SQLite engine on FreeBSD and what compiler symbols you defined for sqlite features.

 

I too am having trouble using the SQLite Managed Library. I have a small program that I've written using the full version of sqlite, but I would like to port it to mono on OSX. Reading the forums, I understand that I need to switch to using the managed library. However, I can't seem to get that to work on windows. I have written a very small simple test application in C# in visual studio 2008 but I can't get it to work. The test app has a query textbox and a results textbox with an "execute" button. What am I doing wrong? If I want to use this application on both windows (.NET) and OSX (mono) will I need to maintain two seperate applications, one with the managed library for OSX and one with the "normal" library for windows?

Without an error message or some kind of inkling what results you are getting, I'm stumped as to how to help you.

How was your version of SQLite compiled?  What compiler flags were used?  What error are you getting?

I have posted my visual studio project on http://oboesax.com/
I downloaded the managed dll for System.Data.SQLite:
SQLite-1.0.60.0-managedonly-binaries.zip

I downloaded the sqlite precompiled dll from sqlite.org for windows and placed it in the project.
sqlitedll-3_6_4.zip

The error I get in windows is: cannot load the dll sqlite3.dll.
I think the errors I'm getting in OSX are because the sqlite3 library that comes with mono 2 either wasn't compiled right or is too old. And unfortunately, for all my programming/database experience, I have very little experience building shared libraries for windows/linux.

I can provide whatever details you require, but I ask that you be patient with my lack of knowledge in this area. It's probably more frustrating for me than for you.

ok the problem is the precompiled sqlite3.dll for windows will not work on OSX.  You'll have to get a hold of, or compile your own more recent library for OSX.

 

Sorry, my fault for combining two issues into one post.

I am trying to write an application in visual studio using System.Data.SQLite that I can compile and run on either windows or OSX (under mono).

Right now, It doesn't work under either system. I am looking for advice on how to pull this off.

my (possibly incorrect) idea was to use the managed-only library which would allow windows to use a windows version of sqlite3.dll and mono to use an OSX version of sqlite3.dll.

obviously, I am in need of being straightened out.

That's pretty much how its supposed to work. 

In my tests, I used OpenSUSE 10.3 and Windows Vista.  My test.exe program ran just fine on both machines once I'd compiled SQLite properly on OpenSUSE.  Just substituted the default System.Data.SQLite with my managed-only version, and placed the sqlite3.dll in the same dir as the app (Windows) ... and for OpenSUSE compiled the shared library and put it ... I forget where.

 

Thank you. I got the app running on Vista. All I had to do was manually copy the sqlite3.dll file into the bin directory. that solution was apparently too simple for me.
I still can't get it to work on mono/osx :-(. osx 10.5 is fully UNIX compatible, so this shouldn't be a big deal. If it works on SUSE it should work on OSX. Here is what I've done

download the source for sqlite-3.6.4:
sqlite-amalgamation-3.6.4.tar.gz (the latest right now)

modify sqlite3.c to add the following at the top of the file:

#define SQLITE_ENABLE_COLUMN_METADATA 1

I then ran:
./configure
make

at this point, I have a directory full of files and I'm not sure where to put which.

sorry to be so thickheaded here, but my googling skills are failing me. Thank you for all your work on this library!