System.Data.SQLite

RESOLVED

 Here's what worked for me.  I did two things.  I'm not totally sure which one did the trick, but I successfully added a SQLite connection to solution in VS 2008.

(1) I went to the properties of the solution (Tools >> Options and in Options "Database Tools" >> Database Connections.  I set the "SQL Server Instance Name" to SQLite Database File

(2) In the Machine.Config file in the Windows Directory, I commented out the default DB Connection type (which was SQLExpress). 

After I did those two things, I did a full reboot.

 After the reboot, when I opened Visual Studio and attempted to add a new connection, I got a much more elaborate dialogue box which included the 'picker' to pick a SQLite Database.  Since had also uploaded the SQLite Northinwind Traders, I pointed to that and clicked "OK".

The installation of the connection completed.  I was dancing and singing.  I still haven't used it or queried the DB but I'm one step further along.

Good times.  Hope this helps.

 i solved the problem of wrong dialog box of SQLite ADO.NET Provider with VS 2005 (italian) following these steps:

1- uninstall SQLite ADO.NET Provider;

2- reset Visual Studio environment with the command START>RUN: devenv /resetsettings and restart Windows (XP in my case);

3- start VS 2005 (starts as first run) then close it; 

4- intall SQLite ADO.NET Provider;

5- start again VS2005 and all is ok now!

nadrm:

 i solved the problem of wrong dialog box of SQLite ADO.NET Provider with VS 2005 (italian) following these steps:

1- uninstall SQLite ADO.NET Provider;

2- reset Visual Studio environment with the command START>RUN: devenv /resetsettings and restart Windows (XP in my case);

3- start VS 2005 (starts as first run) then close it; 

4- intall SQLite ADO.NET Provider;

5- start again VS2005 and all is ok now!

already try, still have same problem...

jaap34:

Fixed... Uninstall 1.0.60.0, run devenv.exe /resetuserdata, install 1.0.60.0 and the connection dialog is back to normal...

get this error when started vs2005 after install sqlite ado.net: "Package Load Failure Package 'SQLite Designer Package' has failed to load properly(GUID={DCBE6C8D-0E57-4099-A183-98FF74C64D9C}). Please contact package vendor for asistance. Application restart is recommended, due the possible environment corruption, Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading"

lance22:

RESOLVED

 Here's what worked for me.  I did two things.  I'm not totally sure which one did the trick, but I successfully added a SQLite connection to solution in VS 2008.

(1) I went to the properties of the solution (Tools >> Options and in Options "Database Tools" >> Database Connections.  I set the "SQL Server Instance Name" to SQLite Database File

(2) In the Machine.Config file in the Windows Directory, I commented out the default DB Connection type (which was SQLExpress). 

After I did those two things, I did a full reboot.

 After the reboot, when I opened Visual Studio and attempted to add a new connection, I got a much more elaborate dialogue box which included the 'picker' to pick a SQLite Database.  Since had also uploaded the SQLite Northinwind Traders, I pointed to that and clicked "OK".

The installation of the connection completed.  I was dancing and singing.  I still haven't used it or queried the DB but I'm one step further along.

Good times.  Hope this helps.

still have same problem...