[Mono-list] Error: sqlite_compile entry point

[Joshua Tauberer]

KielW wrote:
> I'm recieving the following error when trying to use Sqlite..
>>> Unable to find an entry point named 'sqlite_compile' in DLL 'sqlite'.
> 
> I'm using Sqlite version 3.3.9 and Mono 1.2.2.1 <http://1.2.2.1> on Windows
> 
> The sqlite.dll is in the same folder as the application.  I'm using
> Visual Studio, and I added the Mono.Data.Sqlite.dll as a reference to my
> project. 

I think you just need to tack on ";version=3" to the connection string,
or rename sqlite.dll to sqlite3.dll.  iirc, sqlite_compile is a sqlite
version 2 api call --- all of the version 3 calls have a "3" in them.

> ?) Since VS is using its imp. can I not link to the Mono.Data.Sqlite as
> I'm doing?

You can use Mono.Data.SqliteClient with both Mono and MS .NET.

HTH

-- 
- Josh Tauberer

http://razor.occams.info

"Yields falsehood when preceded by its quotation!  Yields
falsehood when preceded by its quotation!" Achilles to
Tortoise (in "Gödel, Escher, Bach" by Douglas Hofstadter)