koobas.hobune.stream
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.
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)
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();
}
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.
