Geek Answers Handbook

System.Data.Sqlite is not recognized by Visual Studio 2010 on a computer with a Win 2K8 server

I have a Windows Server 2008 (64-bit) window in which I am developing. I installed Visual Studio 2010 and System.Data.SQLite (from sqlite.phxsoftware.com). My problem is that the former does not see the latter. That is, when I go to Server Explorer in Visual Studio and select "Connect to Database" and the "Select Data Source" window appears, SQLite does not appear in the list of data sources. Does anyone know what this deal is? This could be a problem with Windows Server 2008, because in the past I had no problems with VS 2010 + System.Data.Sqlite in a Windows 7 window.

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

+7
source share
3 answers

I ran into the same issue with VS2010 and the latest version of the SQLite provider from System.Data.SQLite.org. I have not yet resolved this version, but found that when I deleted it and then installed the previous version (1.0.66.0) from sqlite.phxsoftware.com, it worked fine.

+5
source

I had the same problem ... and just ran through this blog which has a workaround: http://www.tsjensen.com/blog/2011/06/04/SQLite+On+Visual+Studio+2010+ Setup + Instructions.aspx

+7
source

I managed to get this to work if I installed the x86 package. When you install it, it will provide you with an option that is NOT displayed on x64. This will allow you to install the developer tools, where he will ask you to put him in the shared cache. However, it installs the installation in a shared cache.

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

0
source

More articles:


All Articles