x


Can't make unity connect to SQLite database

So I followed the steps to use found in the unity wiki SQLite with javascript but when I tried to compile the code, it gave me this error and I have no clue of what could it be:

EntryPointNotFoundException: sqlite3_next_stmt
Mono.Data.Sqlite.SQLiteBase.ResetConnection (Mono.Data.Sqlite.SqliteConnectionHandle db)
Mono.Data.Sqlite.SQLiteBase.CloseConnection (Mono.Data.Sqlite.SqliteConnectionHandle db)
Mono.Data.Sqlite.SqliteConnectionHandle.ReleaseHandle ()
System.Runtime.InteropServices.CriticalHandle.Dispose (Boolean disposing)
System.Runtime.InteropServices.CriticalHandle.Dispose ()
Mono.Data.Sqlite.SQLite3.Close ()
Mono.Data.Sqlite.SqliteConnection.Close ()
(wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteConnection:Close ()
Mono.Data.Sqlite.SqliteConnection.Open ()
dbAccess.OpenDB (System.String p) (at Assets/Scripts/dbAccess.js:20)
baseDatos.Start () (at Assets/Scripts/baseDatos.js:11)

What am I doing wrong? I've put the sqlite3.dll into the plugins folder I created in my project files, I included Mono.Data.SqliteClient.dll in the Assets folder and also copied my database into it as well. It is not the version since I'm not using the indie version, thanks I would appreciate some help.

more ▼

asked Jul 12 '11 at 02:17 PM

Theil_27 gravatar image

Theil_27
1 1 1 4

Looks like it is complaining about lines 20 and 11, what is the program trying to do there?

dbAccess.OpenDB (System.String p) (at Assets/Scripts/dbAccess.js:20) baseDatos.Start () (at Assets/Scripts/baseDatos.js:11)

Jul 12 '11 at 02:59 PM marek428

in line 20 there is just this sentence:

dbcon.Open();

of this class:

class dbAccess
{
private var connection : String;
private var dbcon : IDbConnection;
private var dbcmd : IDbCommand;
private var reader : IDataReader;

function OpenDB(p : String){
connection = "URI=file:" + p;
dbcon = new SqliteConnection(connection);
dbcon.Open();
}
Jul 12 '11 at 04:45 PM Theil_27
(comments are locked)
10|3000 characters needed characters left

1 answer: sort voted first

Check out this link: http://sqlite.phxsoftware.com/forums/p/1605/6904.aspx

Notably: "The packaged version of SQLite that comes with Ubuntu 8.10 is apparently (3.5.9). The sqlite_next_statement() interface which was missing and causing the exception was added in version (3.6.0 beta). I feel like I missed the bus."

Maybe the dll you have is old? Try to grab a newer one and swap them out.

more ▼

answered Jul 12 '11 at 07:07 PM

marek428 gravatar image

marek428
31 1 1 3

Thank you. :)

Jul 12 '11 at 11:34 PM Theil_27
(comments are locked)
10|3000 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Topics:

x3447
x232
x49

asked: Jul 12 '11 at 02:17 PM

Seen: 1505 times

Last Updated: Jul 15 '11 at 01:53 AM