I'm having a terrible time trying to deploy my SQLite application. I downloaded from System.Data.SQLite.org the file: sqlite-netFx45-setup-bundle-x86-2012-1.0.88.0.exe and installed that on my development machine (Windows 7 Ultimate x64). I actually have 2 development machines, a laptop and a desktop both are Windows7 x64 and both have Visual Studio 2012. I used this particular download file because I enjoy working with EntityFramework and this saved me a lot of valuable time in my development.
I'm using Visual Studio 2012 and I got my application running and everything is great. I configured all the libraries and my main application to build to x86, so that it matched the sqlite installation file. I then copied all the files from the bin\debug directory and placed them on a target machine and made sure the sqlite database file was accessible in the correct location per the exe.config file. both System.Data.SQLite.dll and System.Data.SQLite.Linq.dll were included. Also, per the installation notes, I placed the following code in the Configuration file: <system.data> <DbProviderFactories> <remove invariant="System.Data.SQLite" /> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.88.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> </DbProviderFactories> </system.data> When I run the program on the target machine, the main window comes up fine because it doesn't access the database, but once I bring up a window that does access the database, I get a message stating that the application has stopped working. No error message specific to the problem and then another window from the OS stating that it will try to discover what the problem is, but of course it can't. I've used several machines as the target machine such as Windows 7 Ultimate x64, Windows 7 Ultimate x86, a virtual Windows 7 Ultimate x64, etc. I even tried to install sqlite-netFx45-setup-bundle-x86-2012-1.0.88.0.exe on some of the target machines to see if that would help and it didn't. Each of the target machines has installed the .NET 4.5 update, so that is also not the problem. I'm completely stumped on this issue. I really want to be able to use EntityFramework and love the SQLite database, but this has got me pulling my hair out, (not that I have much anyway. J) Any help would be tremendously appreciated. Sincerely, Paul Bainter _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users