issue accessing SQLite database on Android

Unity Engine
1

Hi all.

I added a SQLite database to my Unity project, all works fine in while I´m working on the Unity IDE, but when I test the game on an Android device the access to the database fails.

Has anyone had the same problem and can tell me how to fix it?

I read in other threads of this forum that other people have had trouble making the build, isn’t my case, I could generate the apk.

Thanks in advance :wink:

2

I finally got it working. The problem was, at least in my case, that Android is based on Linux architecture, so it don’t work with .dll libraries, I must use a .so librerie instead. This does not happen with MonoDevelop’s own libraries; I guess that makes a translation of these libraries in the build, but not with the external libraries like sqlite3.dll.

I put this .so file into /Assets/Plugins/Android and Unity automatically finds it; in the inspector I must select ‘Android’ in ‘Select platforms for puglin’, and ‘AR Mv 7’ in CPU. I hope this will be useful for others with the same problem.

Since .so library is not on the official website of SQLite, if someone needs it, send me a message and I’ll send it by mail.

3

Any chance I could get this as soon as you get the chance? Thanks in advance

4

of course, try this link. Let me know when you have it downloaded.
https://goo.gl/3NyK7z