Re: [sqlite] System.Data.SQLite fails to load

[Drago, William @ MWG - NARDAEAST]

Thanks for the reply.

Everything seems to be working fine, the only thing is I don't see SQLite in 
VEE's drop down box for "Available .NET Assemblies." I'm not sure where that 
list comes from, and I thought that even though SQLite is working, that I might 
not have installed it properly with gacutil.

-Bill

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Joe Mistachkin
Sent: Friday, February 28, 2014 10:24 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] System.Data.SQLite fails to load


Drago, William @ MWG - NARDAEAST wrote:
>
> I solved this problem by deploying the "System.Data.SQLite.dll"
> mixed-mode
assembly to
> the GAC. I know this is not recommended, but it's the only thing that
works.
>

It should be OK, the mixed-mode assembly is designed for these types of cases, 
when an application or environment cannot make use of app-local deployment for 
some reason.

>
> My question now is, I used gacutil.exe instead of the installer that
> comes
with SQLite.
> Was that a mistake? Should I have used the installer? I hate running
installers unless
> I know exactly what they're going to do, that's why I'm asking.
>

Using "gacutil" is fine.  That's more-or-less what the setup packages do.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
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

[Joe Mistachkin]

Drago, William @ MWG - NARDAEAST wrote:
>
> I solved this problem by deploying the "System.Data.SQLite.dll" mixed-mode
assembly to
> the GAC. I know this is not recommended, but it's the only thing that
works.
> 

It should be OK, the mixed-mode assembly is designed for these types of
cases, when an
application or environment cannot make use of app-local deployment for some
reason.

>
> My question now is, I used gacutil.exe instead of the installer that comes
with SQLite.
> Was that a mistake? Should I have used the installer? I hate running
installers unless
> I know exactly what they're going to do, that's why I'm asking.
> 

Using "gacutil" is fine.  That's more-or-less what the setup packages do.

--
Joe Mistachkin

___
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

[Drago, William @ MWG - NARDAEAST]

I solved this problem by deploying the "System.Data.SQLite.dll" mixed-mode 
assembly to the GAC. I know this is not recommended, but it's the only thing 
that works.

My question now is, I used gacutil.exe instead of the installer that comes with 
SQLite. Was that a mistake? Should I have used the installer? I hate running 
installers unless I know exactly what they're going to do, that's why I'm 
asking.

Thanks,
-Bill


-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Incongruous
Sent: Wednesday, February 26, 2014 9:15 AM
To: 'General Discussion of SQLite Database'
Subject: 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
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
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

[Simon Slavin]

On 26 Feb 2014, at 2:15pm, Incongruous  wrote:

> You've sparked my curiosity, what is this VEE programming language?





Hope this helps.

Simon.
___
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

[Incongruous]

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 fails to load

[William Drago]

On 2/26/2014 5:50 AM, Simon Slavin wrote:

On 26 Feb 2014, at 10:19am, William Drago  wrote:


VEE is a graphical programming language similar to NI LabView.

Is this Agilent VEE ?  If it's very like LabView then you shouldn't be using a 
.NET framework at all.

The normal way to use SQLite is to call SQLite API calls from C.  You can 
compile the SQLite library into a standalone app, but instead into an 
addon/toolbox/library as you see fit.


Yes, this is Agilent VEE. I can't use the sqlite3.dll 
directly with VEE. VEE only recognizes a limited number of 
data types and has no idea what typedef is, so I'd have to 
I'd have to write a wrapper for SQLite before I could use it 
(I'd love to do this, but my boss would kill me).


So, .NET is the easiest way to use SQLite with VEE. Also, 
using .NET allows me to reuse some of the ADO.NET libraries 
that I use with MS SQL Server.


I wish VEE was more capable in this regard. Productivity is 
very high in VEE because it does a lot for you, but 
flexibility is what you lose because you have little control 
over how VEE does things.


Thanks for the reply,
-Bill

More about VEE for anyone working in an electronics test & 
measurement environment or the morbidly curious:

http://cp.literature.agilent.com/litweb/pdf/5990-9117EN.pdf



There are numerous SQLite addons for LabView (e.g.





) and they don't use .NET, they address the C API.  I would expect to find 
something similar for VEE, or if not, then to write thin IO library that can 
address a SQLite database using the C API.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4335 / Virus Database: 3705/7124 - Release Date: 02/25/14




___
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

[Simon Slavin]

On 26 Feb 2014, at 10:19am, William Drago  wrote:

> VEE is a graphical programming language similar to NI LabView. 

Is this Agilent VEE ?  If it's very like LabView then you shouldn't be using a 
.NET framework at all.

The normal way to use SQLite is to call SQLite API calls from C.  You can 
compile the SQLite library into a standalone app, but instead into an 
addon/toolbox/library as you see fit.

There are numerous SQLite addons for LabView (e.g.





) and they don't use .NET, they address the C API.  I would expect to find 
something similar for VEE, or if not, then to write thin IO library that can 
address a SQLite database using the C API.

Simon.
___
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

[William Drago]

On 2/25/2014 3:44 PM, Joe Mistachkin wrote:

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?


I'm not sure. VEE is a graphical programming language 
similar to NI LabView. There are a lot of things in VEE that 
are beyond my ability to observe.



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.


If trust issues are the cause of my problem, would a C# 
program targeting 2.0 also fail? If trust issues are 
insurmountable would this be a case for using the GAC?



   Since I do not see
any network share paths in your trace output, I'm not sure if
that is the case here.
There should be network shares in the trace output since I'm 
running the program from the network. It should be looking 
for SQLite in something like 
b:\SomeNetworkFolder\MyAppFolder. Instead it's looking in 
the VEE runtime executable path. I wonder if this is a 
symptom of trust issues.




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.
I point and click on the assemblies I want to use in the VEE 
IDE, and have no control after that.


Anyway, thanks for the help. I have a few things to look 
into, and I may file support request with Agilent if I can 
rule out all issues with my network.


-Bill



--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4335 / Virus Database: 3705/7124 - Release Date: 02/25/14




___
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

[Joe Mistachkin]

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] System.Data.SQLite fails to load

[William Drago]

All,

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.


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.


In the log files below I can see that when I'm running from 
my C:\ drive, everything is fine. But when I run from the 
network the Appbase is incorrect.


I don't know if this is a problem with the network, or with VEE.

Can anyone shed some light on this?

I am using the binaries found in 
sqlite-netFx20-binary-Win32-2005-1.0.91.0.zip


Thanks,
-Bill


Here are the log files...

This is running on C:\

*** Assembly Binder Log Entry  (2/24/2014 @ 5:56:00 PM) ***

The operation was successful.
Bind result: hr = 0x0. The operation completed successfully.

Assembly manager loaded from: 
C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll
Running under executable  C:\Program Files (x86)\Agilent\VEE 
Pro 9.3\vee.exe

--- A detailed error log follows.

=== Pre-bind state information ===
LOG: User = XX\WDRAGO
LOG: DisplayName = System.Data.SQLite, Version=1.0.91.0, 
Culture=neutral, PublicKeyToken=db937bc2d44ff139

 (Fully-specified)
LOG: Appbase = file:///C:/SQLite_Test/
LOG: Initial PrivatePath = NULL
LOG: Dynamic Base = NULL
LOG: Cache Base = NULL
LOG: AppName = vee.exe
Calling assembly : Vee2net, Version=9.32.17704.1, 
Culture=neutral, PublicKeyToken=null.

===
LOG: This bind starts in LoadFrom load context.
WRN: Native image will not be probed in LoadFrom context. 
Native image will only be probed in default load context, 
like with Assembly.Load().

LOG: No application configuration file found.
LOG: Using machine configuration file from 
C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: System.Data.SQLite, 
Version=1.0.91.0, Culture=neutral, 
PublicKeyToken=db937bc2d44ff139

LOG: GAC Lookup was unsuccessful.
LOG: Attempting download of new URL 
file:///C:/SQLite_Test/System.Data.SQLite.DLL.
LOG: Assembly download was successful. Attempting setup of 
file: C:\SQLite_Test\System.Data.SQLite.dll

LOG: Entering run-from-source setup phase.
LOG: Assembly Name is: System.Data.SQLite, Version=1.0.91.0, 
Culture=neutral, PublicKeyToken=db937bc2d44ff139
LOG: Where-ref bind Codebase matches what is found in 
default context. Keep the result in default context.

LOG: Switch from LoadFrom context to default context.
LOG: Binding succeeds. Returns assembly from 
C:\SQLite_Test\System.Data.SQLite.dll.

LOG: Assembly is loaded in default load context.



This is what happens when I try running from a network drive:



*** Assembly Binder Log Entry  (2/24/2014 @ 5:59:40 PM) ***

The operation failed.
Bind result: hr = 0x80070002. The system cannot find the 
file specified.


Assembly manager loaded from: 
C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll
Running under executable  C:\Program Files (x86)\Agilent\VEE 
Pro 9.3\vee.exe

--- A detailed error log follows.

=== Pre-bind state information ===
LOG: User = XX\WDRAGO
LOG: DisplayName = System.Data.SQLite, Version=1.0.91.0, 
Culture=neutral, PublicKeyToken=db937bc2d44ff139

 (Fully-specified)
LOG: Appbase = file:///C:/Program Files (x86)/Agilent/VEE 
Pro 9.3/

LOG: Initial PrivatePath = NULL
LOG: Dynamic Base = NULL
LOG: Cache Base = NULL
LOG: AppName = vee.exe
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files 
(x86)\Agilent\VEE Pro 9.3\vee.exe.config
LOG: Using machine configuration file from 
C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: System.Data.SQLite, 
Version=1.0.91.0, Culture=neutral, 
PublicKeyToken=db937bc2d44ff139

LOG: GAC Lookup was unsuccessful.
LOG: Attempting download of new URL file:///C:/Program Files 
(x86)/Agilent/VEE Pro 9.3/System.Data.SQLite.DLL.
LOG: Attempting download of new URL file:///C:/Program Files 
(x86)/Agilent/VEE Pro 
9.3/System.Data.SQLite/System.Data.SQLite.DLL.
LOG: Attempting download of new URL file:///C:/Program Files 
(x86)/Agilent/VEE Pro 9.3/System.Data.SQLite.EXE.
LOG: Attempting download of new URL file:///C:/Program Files 
(x86)/Agilent/VEE Pro 
9.3/System.Data.SQLite/System.Data.SQLite.EXE.

LOG: All probing URLs attempted and failed.




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users