Connecting to a SQLite database from visual studio 2008

Question

I did write some apps in the past that used access en sqlserver databases. These databases come with wizards however to help you create a connection to it.

Now, I want to add a new db connection in the Server explorer of visual studio 2008 to SQLite. I referenced the System.Data.SQLite assembly from phxsoftware. I am able to select the SQLite Database File (.NET Framework Data Provider for SQLite) as a Datasource. Then I tried to add as the connection string: Data Source=g:\testsqlite.s3db; Version=3 (a database file I constructed using SQLite administrator).

When I hit the Test Connection button all seems to be fine, but when I hit OK, visual studio greets me with a message box that an unexpected error has occurred in the .Net Framework Dataprovider for Sqlite.

What am I doing wrong?

Answer 1

The question is discussed here Jaap34's answer solved the problem in my case. Actually when you see a screen that gives you only the option to enter a connection string you know you have run into an incompatibility issue. Uninstalling sqlite ADO provider, running devenv.exe /resetuserdata and reinstalling the ADO provider will give you a much more elaborate screen that gives you the possibility to browse to the database file.

Answer 2

After your SQLite installation just restart your Visual Studio.