System.Data.Sqlite not being recognized by Visual Studio 2010 on Win 2K8 Server machine

Question

I have a Windows Server 2008 (64-bit) box that I am doing development on. I've installed Visual Studio 2010 and System.Data.SQLite (from sqlite.phxsoftware.com). My problem is that the former is not seeing the latter. That is, when I go to the Server Explorer in Visual Studio and select "Connect to Database" and the "Choose Data Source" window appears, SQLite does not appear under the list of data sources. Anyone know what the deal is with that? Could it be an issue with Windows Server 2008 because in the past I've no issues with VS 2010 + System.Data.Sqlite on a Windows 7 box.

Update: System.Data.SQLite and System.Data.SQLite.Linq assemblies are showing up in my GAC

Misology

Answer 1

I'm running into the same issue with VS2010 and the latest version of the SQLite provider from System.Data.SQLite.org. I haven't resolved it yet with that version, but I did find that when I uninstalled it and then installed the previous version (1.0.66.0) from sqlite.phxsoftware.com it worked just fine.

Cuba

1.0.66.0 is the latest version. Did you mean that you installed 1.0.65.0? – Misology

The current version at System.Data.SQLite.org is 1.0.73.0. With that version I had the problem you described. The problem was resolved after I uninstalled 1.0.73.0 and installed an older version from sqlite.phxsoftware.com. I don't have access to the test environment I was using, but I'm pretty sure it was 1.0.66.0 as mentioned in my email. – Cuba

Answer 2

EDIT - 2018-06-15: Updated non-working link, and changed answer to reflect improvements over the years with managing project dependencies.

---

I had the exact same issue...and just ran across this blog that has a workaround:

Original link (considered obsolete by author): http://www.tsjensen.com/blog/post/2011/06/04/SQLite+On+Visual+Studio+2010+Setup+Instructions

New link (still relevant): http://www.tsjensen.com/blog/post/2012/11/10/SQLite-on-Visual-Studio-with-NuGet-and-Easy-Instructions

TL;DR: Use the System.Data.SQLite(x86/x64) Nuget package.

Goncourt

Answer 3

I was able to get this to work if I installed the x86 bundle. When you install that one, it will give you an option that does NOT appear in the x64. It will allow you to install the designer tools, where it asks you about putting it in the general cache. It does force the install to the general cache however.

The package that worked for me was: sqlite-netFx40-setup-bundle-x86-2010-1.0.80.0.

Democrat