Unable to load DLL 'sqlite3': in windows phone app.

Question

I'm working on a windows Phone OLD application. I'm getting this issue related to SQL3.dll. in visual 2015.

Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

What I've tried, Done Cleaning all project, added sqlite.dll in Bin/debug folder, but I could not overcome this issue. here is a screenshot.

I've tried adding a dll as reference (sqlite-winrt-3220000.vsix) but this is not compatible. Any help would be appreciated.

Answer 1

Add the dll as a reference:

1. Right-click in "References" in the project you want to use it in and select "Add reference".
2. Select the option "Browse" and use the browse button to select the dll you want to include.
3. Add a using statement to the class.

After this you can use the dll in the project.

Answer 2

I've tried adding a dll as reference (sqlite-winrt-3220000.vsix) but this is not compatible.

SQlite is distributed as a VS extension. To add reference to your project, right click on References, “Add References”, “Windows Phone 8”, “Extensions”, check “SQLite for Windows Phone”, press OK.

No other steps are required, you don’t need other references and you don’t need to specify or deploy DLLs manually.

Also sqlite has different extension for WP8.1, you should probably install another one, sqlite-wp81-winrt-3220000.vsix.

Update: I think you’re trying to build for a platform that’s unsupported by SQLite library. SQlite for windows phone only supports 2 platforms, intel 32 bit (for emulators) and ARM (for devices and for the marketplace). It does not support AMD64, and it does not support “Any CPU”. You’re probably trying to build “Any CPU”, it’s usually the default platform for .NET.

Another possible reason is wrong project type. Your project has to be windows phone 8.1 app, not universal, i.e. the project name in the solution explorer panel must end with ”(Windows Phone 8.1)”

Update 2: I’ve compiled a simple app that uses sqlite, run it in emulator and it worked flawlessly on my PC. Ensure your references look like this:

If you have the same, make sure you have VS 2015 Update 3 installed. If you already have it, repairing your visual studio installation might help.