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
4
Question by FuDaNing · Mar 30, 2015 at 02:42 PM · unity5sqlite

Update to Unity 5, then DllNotFoundException: sqlite3

Hi, I am working with SQLite for some weeks. Everything goes well untill I updated my Unity version to 5.

My 'Mono.Data.Sqlite.dll' and 'System.Data.dll' are copies form 'Unity\Editor\Data\MonoBleedingEdge\lib\mono\2.0'. And put them at 'Plugins' folder.

Unity version: 5.0.0f4 Personal

Error Log: Data Source=D:/eProjects/Unity/老婆的记账本/Assets/xyc.db, System.DllNotFoundException: sqlite3 at (wrapper managed-to-native) Mono.Data.Sqlite.UnsafeNativeMethods:sqlite3_open_v2 (byte[],intptr&,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 (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteConnection:Open () at DbAccess.OpenDB (System.String connectionString) [0x0000c]

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 ElBuho · Apr 14, 2015 at 10:14 PM 0
Share

When you got that message? during the runtime?

avatar image sys12 · Jul 08, 2015 at 01:18 PM 0
Share

老婆的记账本 lol

2 Replies

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

Answer by submiting · Apr 15, 2015 at 05:32 AM

You need to use sqlite3 x64 due to unity5 editor is x64. I had the same issue. Downloading the following sqlite3-64.dll assembly and renaming to sqlite3.dll helped me: http://blog.synopse.info/post/2013/03/23/Latest-version-of-sqlite3.dll-for-Windows-64-bit

Comment
Add comment · Show 6 · 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 wulveagfin · Apr 27, 2015 at 02:19 AM 0
Share

Does anyone have a mirror to this?

avatar image Bunny83 · Apr 27, 2015 at 02:34 AM 0
Share

@wulveagfin: Why do you want a mirror? The links look like they still work. It's a 7-zip archive so make sure you have 7zip or an archive program that supports 7z files.

avatar image wulveagfin · Apr 27, 2015 at 03:49 AM 0
Share

@Bunny83 the link was broken but finally worked for me.

And this is the correct answer for anyone else who happens upon this. Fixed me right up.

avatar image FuDaNing · Apr 27, 2015 at 04:26 AM 1
Share

Thanks for your replies~ Finally, I solved this by ????. Use ".so" file, and c/c++ extern functions.

avatar image ElBuho · Jul 08, 2015 at 01:43 PM 0
Share

This works for me, with the '.so' file

Show more comments
avatar image
4

Answer by azolson1 · Dec 28, 2016 at 05:13 PM

rather than downloading from a random blog, you can download the correct SQLite library from the official site here

The download that worked for me on that page was 64-bit DLL (x64) for SQLite version 3.15.2.. The zip file contains sqlite3.dll.

hope that helps

Comment
Add comment · Show 1 · 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 Warped · Jan 02, 2019 at 03:27 PM 0
Share

Thanks! Thats helped!

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

9 People are following this question.

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

Related Questions

SqliteException: SQLite error no such table 1 Answer

[Unity] Problem with SQLite on Android 2 Answers

Mono.Data.Sqlite.SqliteConnection.SetPassword() support 1 Answer

can db sqlite sync after build? 0 Answers

Sqlite database doesn't work on Unity games build to Android Devices 3 Answers


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