I'm wondering if there is a bug somehow in the "System.Data.SQLite" dll file.
When deploying my application to a clean Windows 7 x64 virtual machine (VMWare Workstation 10), I got the message "Failed to find or load the registered .NET Framework Data Provider" and of course with no database the app would crash. I then installed the file: "sqlite-netFx45-setup-bundle-x86-2012-1.0.88.0.exe" (retrieved from your web site) to this clean machine. I did NOT install it to the GAC which of course also eliminated the Visual Studio Design stuff. At that point, I ran my app again and it worked as expected. I then went into the control panel and uninstalled "System.Data.SQLite" and then tried running the application again and it worked. Quite a mystery there. Seems like there is something that the "sqlite-netFx45-setup-bundle-x86-2012-1.0.88.0.exe" installation file is installing on the machine that is required for the database to be recognized. The application has the correct SQLite dll files which matched the ones installed by the "System.Data.SQLite" installation file, so it's not a missing dll, at least it's not missing "System.Data.SQLite.dll" or "System.Data.SQLite.Linq.dll" as those are both put into the bin\debug directory from the Visual Studio project. I really enjoy working with the SQLite database, but I need it to work without having to run the "System.Data.SQLite" installation. I know that's a mute-point because I don't believe that is what you guys intended either. It's a pretty simple scenario, so hopefully I've given enough information to help diagnose what is going on. If there is any other information that would be helpful, please let me know. Thank you very much for your help on this issue. Sincerely, Paul Bainter _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
