x


System.Data.SQLite : Running on iOS, Windows not on Android

I am using the following dll's from System.Data.SQLite

SQLite.Interop.dll

System.Data.SQLite.dll

On iOS and Windows Unity Editor the following code creates the SQLite DB and is able to pull data back from it. When deploying to android it does not create the DB. I am perplexed and the data I've read via google is unclear on the next steps to remediate this.

Code Excerpt:

appDBPath = Application.persistentDataPath + "/datastore.s3db";

DataAccess oDao =

new DataAccess(@"Data Source=" + appDBPath + ";UseUTF8Encoding=True;Version=3;Password=SomePass;");

Excerpt from DataAccess.cs

public DataAccess(string ConnectionString){
    SQLConn = new SQLiteConnection(ConnectionString);
    SQLConn.Open();
    Debug.Log("Connected to the SQLite DB");

}
more ▼

asked Mar 25 '12 at 02:39 PM

digitalroar gravatar image

digitalroar
-3 2 2 2

I'm curious to know what you did to get System.Data.SQLite dlls to work inside Unity at all. I see all the packages say that .NET 3.5 or 4.0 are required, but Unity only uses 2.0 AFAIK. I've tried to implement the 32-bit .NET 3.5 binaries, but Unity throws errors at runtime on the SQLite.Interop.dll not being found, even thought it's clearly in the Plugins folder...

Nov 25 '12 at 06:37 PM MZGS
(comments are locked)
10|3000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
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:

x2488
x49
x3

asked: Mar 25 '12 at 02:39 PM

Seen: 996 times

Last Updated: Nov 25 '12 at 06:37 PM