koobas.hobune.stream
SQLite Error on iOS
SQLite on iOS - error: Unable to resolve pinvoke method 'Mono.Data.SqliteClient.Sqlite:sqlite_open (string,int,intptr&)' Re-run with MONO_LOG_LEVEL=debug for more information.
I'm running Unity 3.5.6 and developing an iOS project with XCode 4.5, using SQLite from within C#. I've copied the DLLs System.Data.dll and Mono.Data.SqlLiteClient to the Plugins folder, too. It's working inside the editor.
When running on iOS I'm receiving this error:
Unable to resolve pinvoke method 'Mono.Data.SqliteClient.Sqlite:sqlite_open (string,int,intptr&)' Re-run with MONO_LOG_LEVEL=debug for more information.
Anyone has an idea how to fix it?
i have now tried all kinds of unity versions (3.5.5 and 3.5.6) in combination with different xcode versions (4.5 and 4.4.1) as well as example projects for iOS from other people. it seems like SQLit is not working anymore on iOS 6 from within C#. When accessing it from javascript, it still works. i'll now try downgrading the iPad to 5.1.1 ...
P/Invoke is a method used on PCs to get from c# code into Windows native code. Your getting the error tells me that the DLLs you have are intended for use on Windows. I doubt that they will ever work on iOS. iOS has native support for SQLite, so I think you'd be better off using iOS plugins in Unity and calling into the Apple libraries rather than trying to use Windows DLLs. (Search in the asset store for some plugins that can talk to SQLite databases.)
If you're interested, I've developed a plugin that has all the connections sorted out, for all platforms, and it also makes database integration extremely simple, since it allows you to store and retrieve data without writing queries.
Case you want to check it out, here's the link to the asset store page:
This post was made over 3 years ago and has already been answered - please don't advertise your product by reviving irrelevant threads - that is not the purpose of Unity Answers.
I have purchased sqliteKit from the Asset Store and it is working on iOS 5.1.1 as well as iOS 6 now.
