Not sure what happened to this post previously, so I guess I'll try it again
with some additional information
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. As always, I have this
following section in the App.config file and the App.config file is
appropriately named "appname.exe.config", which is one of the things that
Visual Studio does for me automatically. I've also checked that particular
file just to make sure.
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.
So in summary, my app does not work before installing System.Data.SQLite and
then works after installing System.Data.SQLite and continues to work after
uninstalling System.Data.SQLite. I don't see this as a problem with the
App.config file as it has the correct entries per the instructions from the
installation. Whatever help you can give me on this would be appreciated.
Sincerely,
Paul Bainter
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users