Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 13 Next capture
2021 2022 2023
1 capture
13 Jun 22 - 13 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
0
Question by Polkovskoi · Jan 09, 2015 at 11:26 AM · sqlite

DllNotFoundException: sqlite3

Hello! I'm trying to solve the problem for a long time, maybe there is something I miss. I work with SQLite. Everything works fine at PC (Windows). While trying to open connection to the database at Android, I get the following exception: System.DllNotFoundException: sqlite3 at (wrapper managed-to-native) Mono.Data.SQLite.UnsafeNativeMethods:sqlite3_open_v2 (byte[],intprt&,int,intptr) at Mono.Data.SQLite.SQLite3.Open (System.String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool) [0x00000] in :0 at Mono.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0 at IVI_GameManager.connectToDB () [0x00000] in :0

The files in the folder "Plugins" of the project are:

  1. Mono.Data.Sqlite.dll;

  2. sqlite3.dll;

  3. System.Data.dll;

The code openning the connection is:

 IDbConnection dbcon = new SqliteConnection(connectionString);
  dbcon.Open();

Unity Version: 4.6.1f1

Please, tell me the ways to solve the issue.

Comment
Add comment · Show 2
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Graham-Dunnett ♦♦ · Jan 09, 2015 at 11:28 AM 0
Share

Um, if it works on a pc then the sqlite3dll is an intel one. It won't then work on an Android device with presumably an arm core. (Unless these are c# assemblies.)

avatar image Gilead7 · Dec 30, 2016 at 12:39 AM 0
Share

What about for a $$anonymous$$indle Fire build? What DLLs are needed?

3 Replies

· Add your reply
  • Sort: 
avatar image
4
Best Answer

Answer by Polkovskoi · Jan 09, 2015 at 01:55 PM

The probllem is solved this way: besides Mono.Data.Sqlite.dll, sqlite3.dll and System.Data.dll it is necessary to use library libsqlite3.so. Pay attention that for ARM and x86 you need different libraries. To use the needed library version, depending on type of device (ARM or x86), it is necessary to create the folder "Android" in the folder "Plugins", folder "libs" in "Android", "armeabi-v7a" and "x86" in folder "libs", in which you shoud place the corresponding versions the libraries. Like this: alt text

You can download the version of the library for the x86 here and for ARM here.


hierarchy plugins.png (3.3 kB)
Comment
Add comment · Show 3 · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image erik_wagner · Aug 05, 2015 at 06:55 PM 0
Share

I tried this solution but still get the same error. Actually my problem might be slightly different from yours in that it works fine in the editor but not so on a standalone or android compile.

avatar image MrHometown erik_wagner · Jul 07, 2016 at 04:06 PM 0
Share

$$anonymous$$aybe a bit to late, but a solution for Windows I didn´t found at the Internet was simply changing the architecture in the Build Settings from x86 to x86_64!

avatar image wocalage · Dec 14, 2016 at 10:05 AM 0
Share

thank you so much! it help me!

avatar image
0

Answer by sudhindra21 · Mar 30, 2018 at 11:51 AM

Please help in solving this problem... Thanks in advanceError Img


error.png (129.9 kB)
Comment
Add comment · Show 2 · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image nishakk94 · Jun 04, 2019 at 08:18 PM 0
Share

Were you able to fix this?

avatar image BotelloAbraham · Jun 01, 2020 at 08:17 PM 0
Share

Hi. I had that problem. You need have all dll and files of Plugins.rar of "https://github.com/walidabazo/SQLiteUnity3d_Android" on your Assets file on your proyect.

avatar image
0

Answer by cdr9042 · Jan 29, 2021 at 03:34 AM

If you still get the error after adding SQL's dll, try installing .NET Framework 3.5 https://www.microsoft.com/en-us/download/details.aspx?id=21

Comment
Add comment · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

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

Answers Answers and Comments

11 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Sqlite db error build iphone4 0 Answers

Clearing cached sqlite 1 Answer

Database (SQLite) Setup for Unity 0 Answers

Spatialite under Unity 0 Answers

SQLite and Lists in C# 1 Answer


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges