Re: [sqlite] System.Data.SQLite Deployment Mystery
Oh boy! This sounds like another good reason to stay with C++.
.Net is becoming more and more problematic as I explore it.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Monday, March 17, 2014 12:34 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.Data.SQLite fails to load
You've sparked my curiosity, what is this VEE programming language? Is there a web site I can go to read more about it? -Original Message- From: Joe Mistachkin Sent: Tuesday, February 25, 2014 3:44 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite fails to load William Drago wrote: I am using System.Data.SQLite with a relatively uncommon language called VEE. This is an interpreted language that runs in a 32bit development/runtime environment. I've never heard of this language before; however, it sounds like it hosts the CLR within its process? My application works fine when run on an internal or USB thumb drive. However, if I try running it from a network drive SQLite fails to load. For the 2.0 .NET Framework, loading assemblies from a network share can be complicated by trust issues. Since I do not see any network share paths in your trace output, I'm not sure if that is the case here. One thing that I'm noticing is that the successful load uses the "LoadFrom context" and the failed load uses the default context. I'm not sure how the VEE code loads the System.Data.SQLite assembly (or other assemblies); however, maybe try using the "LoadFrom context" when loading from the network share as well. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.Data.SQLite documentation
Yes! Thanks man, keep it smooth dude... you got it right. -Original Message- From: Joe Mistachkin Sent: Thursday, February 13, 2014 10:34 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite documentation Incongruous wrote: Dude! Something must've happened to that file, there is a tree in the Contents tab, but it doesn't matter which help file I click on nothing gets displayed. The help files do not have any data in them! What did I do wrong? Not being able to open a downloaded CHM file is a security feature of Windows, see the Microsoft KB article: http://support.microsoft.com/kb/902225 To summarize the workaround mentioned in the above MS KB article: In order to be able to correctly view the CHM file, right-click it, go to the "Properties" tab, click the "Unblock" button, and then click the "Apply" button. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.Data.SQLite documentation
Thanks for the help Joe Mistachkin. Dude! Something must've happened to that file, there is a tree in the Contents tab, but it doesn't matter which help file I click on nothing gets displayed. The help files do not have any data in them! What did I do wrong? -Original Message- From: Joe Mistachkin Sent: Thursday, February 13, 2014 9:42 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite documentation Incongruous wrote: So, please, point me out to the location of the documentation for System.Data.SQLite. https://system.data.sqlite.org/index.html/doc/trunk/Doc/SQLite.NET.chm?mimet ype=application/x-chm Also, please see the FAQ: https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki And the download page: https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.Data.SQLite documentation
After searching the archives for this year, I was really surprised that no one has ever asked for the documentation of System.Data.SQLite! I am very new in C# and with my little bit of knowledge I really need a lot of help for... even for just opening a connection to the database. I know that a little bit of knowledge of ‘LINQ’ might help me [ I think ], but when creating a wrapper in C++ for SQLite, I did not need to ask too many questions, since it is all there in the documentation. I am really hoping that such documentation exist, otherwise I am going to drive you crazy with all my question and I am not looking forward to that. So, please, point me out to the location of the documentation for System.Data.SQLite. Thanks in advance ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C# - SQLite - and other things
After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and uncompressing it, I got this list of file: Installer.exe Installer.pdb northwindEF.db SQLite.Designer.dll SQLite.Designer.pdb SQLite.Designer.xml SQLite.Interop.dll SQLite.Interop.pdb sqlite_file_list.txt System.Data.SQLite.dll System.Data.SQLite.Linq.dll System.Data.SQLite.Linq.pdb System.Data.SQLite.Linq.xml System.Data.SQLite.pdb System.Data.SQLite.xml test.db test.exe test.exe.config test.pdb testlinq.exe testlinq.exe.config testlinq.pdb [ I tried the intaller.exe, but I get a msg saying: Cannot continue, the "confirm" option is not enabled. ] I have a project that looks like this: Project: | pro.exe\ | |---> image \ | |---> gui \ | |---> mylib \ | |---> sound \ | |---> sqlite \ | mysqlite.cs---|--->%PATH% |__>SQLite.Designer.dll SQLite.Designer.xml SQLite.Interop.dll System.Data.SQLite.dll System.Data.SQLite.Linq.dll The files contained in the sqlite-netFx451-static-binary-x64-2013-1.0.90.0 are located in a folder that exists in the %path%, but I cannot stop to wonder if all the files are necessary or if all I need is the DLLs in order to reference the methods in the database, and if I only need certain files, which ones are those? My second question is, how can I add the DLLs from sqlite-netFx451-static-binary-x64-2013-1.0.90.0 to the ‘mysqlite.cs’ file in order to reference the its methods? I know that this question is unrelated to SQLite, but in its answer is my complete understanding of the solution provided. Any help would be much appreciated. Thanks in advance. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
