Dear Joe,
Thank you for your helpful comments. Ive finally got it going on naïve Win 8 (and Win 7) computers, but I dont understand why!! In short, I got it going by adopting the technique described here: http://rashimuddin.wordpress.com/tag/sqlite-interop-dll/ Perhaps you can suggest why this has worked? Yours Sincerely, Andy Pybus From: Joe Mistachkin-3 [via SQLite] [mailto:ml-node+s1065341n74574...@n5.nabble.com] Sent: Monday, 17 March 2014 3:35 PM To: dpybus Subject: Re: System.Data.SQLite Deployment Mystery dpybus wrote: > > I have an identical problem. I cannot deploy an app which uses either Net 4.5 > or 4.5.1 with the appropriate sqlite dll. It can be fixed by installing the > sqlite package on the target computer. > Generally, there are three types of issues with System.Data.SQLite deployment: 1. Attempting to use the native interop assembly (or native library) without the necessary Microsoft Visual C++ Runtime Libraries installed. 2. Attempting to use the 32-bit native interop assembly (or native library) in a 64-bit process or vice-versa. 3. Loading the managed-only System.Data.SQLite assembly in such a way that it cannot locate its associated native interop assembly (or native library). With the introduction [and refinement] of the "native library pre-loading" feature, this frequency of this issue has declined significantly. One way to see this type of issue is to install the managed-only System.Data.SQLite assembly in the GAC without making the associated native interop assembly available somewhere in the PATH. In this case, I suspect the problem is #1. Running the free Dependency Walker tool (from http://dependencywalker.com/ ) against the native interop assembly ("SQLite.Interop.dll") on the target machine should reveal if that is the case. If that does turn out to be the case, it can normally be solved by installing one of the packages from: https://support.microsoft.com/kb/2019667 -- Joe Mistachkin _______________________________________________ sqlite-users mailing list [hidden email] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _____ If you reply to this email, your message will be added to the discussion below: http://sqlite.1065341.n5.nabble.com/System-Data-SQLite-Deployment-Mystery-tp 71752p74574.html To unsubscribe from System.Data.SQLite Deployment Mystery, click here <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscr ibe_by_code&node=71752&code=ZHB5YnVzQGJpZ3BvbmQubmV0LmF1fDcxNzUyfDEwMTA2OTE1 Njk=> . <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=macro_vi ewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.Basic Namespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template. NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_e mails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> NAML -- View this message in context: http://sqlite.1065341.n5.nabble.com/System-Data-SQLite-Deployment-Mystery-tp71752p74660.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
