[Mono-list] mono.data.sqlite mono1.2.4 on windows... needed dll?

[Xavi de Blas]

Hello

If i use the sqlite.dll from:
http://www.sqlite.org/download.html

then, i got an encoding error:

[Invalid UTF-8]
Unhandled Exception: Mono.data.Sqlite.SqliteException: sqlite error
\xe6\x95\xae\xe7\.........

at Mono.Data.Sqlite.Sqlite3.Prepare (....)

I tried with different encodings and nothing...

I don't know if it's a problem with the Mono 1.2.4 Command Prompt

Anyone succeded on using mono1.2.4 + sqlite with new style assemblie
described here?
http://www.mono-project.com/SQL_Lite

Thanks


2007/7/16, Kamil Skalski <kamil.skalski at gmail.com>:
> You need a native Sqlite library from
> http://www.sqlite.org/download.html
>
> Probably on linux it is already on your system.
>
> 2007/7/13, Xavi de Blas <xaviblas at gmail.com>:
> > Hello all
> >
> > I'm trying to use the new assemblie Mono.Data.Sqlite with mono.1.2.4
> > on windows (on linux works)
> >
> > As read here:
> > http://www.mono-project.com/SQLite
> >
> > i tried this:
> >
> > using Mono.Data.Sqlite;
> > ...
> > static string connectionString = "version = 3; Data source = " + sqlFile;
> >
> > compiled with:
> > -r:Mono.Data.Sqlite
> >
> > and on windows does not work, because it needs the sqlite3.dll.
> >
> > I have some questions:
> >
> > 1.- Why does need this dll on windows and not in linux?
> > 2.- where do i download this dll? i tried some of them, renamed to
> > sqlite3.dll and none work. Does anyone succeded?
> > If i rename the linux file: /lib/mono/2.0/Mono.Data.Sqlite.dll to
> > sqlite3.dll on windows and i put on running dir, it says:
> > Unhandled exception: System.EntryPointNotFoundException: sqlite3_open
> >
> >
> > Also i think the connection string format for this new assemblie ins
> > not ok on the site:
> > http://www.mono-project.com/SQLite
> >
> > Instead of:
> > Data Source=file:SqliteTest.db
> > Should be (i think)
> > Data Source=SqliteTest.db
> >
> >
> > Thanks to all
> > _______________________________________________
> > Mono-list maillist  -  Mono-list at lists.ximian.com
> > http://lists.ximian.com/mailman/listinfo/mono-list
> >
>
>
> --
> Kamil Skalski
> http://nazgul.omega.pl
>