date:20170223

Re: [sqlite] SQLite.Interop.dll

2017-02-23 Thread Barry Smith

Oh, I do remember having this issue before.

I think the cause is this: Visual studio attempts to trace which dlls are 
required for each project. Then if project A is dependent on project B, visual 
studio will copy what it thinks is all the required dlls for both projects into 
project A's output directory.

Unfortunately visual studio is only so smart and doesn't realise that the 
SQLite.interop.dll is a required dependency. I believe the NuGet package puts 
instructions to move those dlls to the output directory by means of xcopy. So, 
you have this situation:

Project GlobalSQLite, with reference to SQLite.
Project GeneologyControls, with reference to GlobalSQLite.

Tell visual studio to build and it goes and executes the step where the SQLite 
interop DLL is copied to the output of the GlobalSQLite project. But then it 
builds GeneologyControls and doesn't realise it needs to copy the interop DLLs! 
So finally your program executes in the output directory of the 
GeneologyControls project, but the SQLite.interop.dll files are in the output 
of the other project.

You need to ensure that the SQLite interop dlls are in the final output 
directory (and also included when you distribute your application). You can do 
this manually using windows explorer, or you can put in a pre or post build 
event of your final project to copy the x64 and x86 folders (containing the 
SQLite.interop.dll files) into its output directory. Doing it from Windows 
explorer is easier, but you may forget then if you do a clean build a few years 
down the line you'll run into the problem again.

Perhaps there's a cleaner way to do this. Those were my solutions, though...

> On 23 Feb 2017, at 1:58 PM, Clyde Eisenbeis  wrote:
> 
> ---
> About two years ago, I downloaded and installed SQLite.  I don't
> recall the details, but it was a program that installed SQLite.
> 
> I ended up with files such as EntityFramework.dll,
> EntityFramework.SqlServer.dll, System.Data.SQLite.dll, etc.  This
> required "using System.Data.SQLite".
> 
> ---
> I then created a WPF C# genealogy program ... and a GlobalSQLite.dll
> library (as a WPF Custom Control Library).
> 
> The GlobalSQLite.dll library contains commonly used functions.  For example:
> 
>   boCreateFileAndTables(string stPathFilename,
> List liststTableNames,
> List liststFieldDefinitions)
>   {...}
> 
> ---
> I am working to improve / clean up the original code for WPF C#
> genealogy program.
> 
> When I have SQLite installed on my genealogy program and on my
> GlobalSQLite.dll library, it works fine.
> 
> When I don't have SQLite installed on my genealogy program, I get an
> exception "Unable to load DLL 'SQLite.Interop.dll'".  It occurs in my
> GlobalSQLite.dll library program:
> 
>sqliteConn = new System.Data.SQLite.SQLiteConnection("Data
> Source=" + stPathFilename + ";").
> 
> I do find SQLite.Interop.dll under ...
> GlobalsSQLite\packages\System.Data.SQLite.Core.1.0.101.0\build\net46\x86
> ... and under ... \x64.
> 
> Is there a better place to put SQLite.Interop.dll so it works?
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite.Interop.dll

2017-02-23 Thread Clyde Eisenbeis

---
About two years ago, I downloaded and installed SQLite.  I don't
recall the details, but it was a program that installed SQLite.

I ended up with files such as EntityFramework.dll,
EntityFramework.SqlServer.dll, System.Data.SQLite.dll, etc.  This
required "using System.Data.SQLite".

---
I then created a WPF C# genealogy program ... and a GlobalSQLite.dll
library (as a WPF Custom Control Library).

The GlobalSQLite.dll library contains commonly used functions.  For example:

   boCreateFileAndTables(string stPathFilename,
 List liststTableNames,
 List liststFieldDefinitions)
   {...}

---
I am working to improve / clean up the original code for WPF C#
genealogy program.

When I have SQLite installed on my genealogy program and on my
GlobalSQLite.dll library, it works fine.

When I don't have SQLite installed on my genealogy program, I get an
exception "Unable to load DLL 'SQLite.Interop.dll'".  It occurs in my
GlobalSQLite.dll library program:

sqliteConn = new System.Data.SQLite.SQLiteConnection("Data
Source=" + stPathFilename + ";").

I do find SQLite.Interop.dll under ...
GlobalsSQLite\packages\System.Data.SQLite.Core.1.0.101.0\build\net46\x86
... and under ... \x64.

Is there a better place to put SQLite.Interop.dll so it works?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.data.SQLite documentation

2017-02-23 Thread Graham Holden

I've seen those symptoms with other CHM files if they're on a network share. If 
that's the case for you, try copying to a local drive.
Graham

Sent from my Samsung Galaxy S7 - powered by Three
 Original message From: Mickey Feldman  
Date: 23/02/2017  12:45  (GMT+00:00) To: sqlite-users@mailinglists.sqlite.org 
Subject: [sqlite] System.data.SQLite documentation 
I am not able to read SQLite.NET.chm, I see only the left hand panel, 
but not the expanded contents.  Is this a known issue, or perhaps an 
issue with Windows 7? Is this documentation available anywhere else or 
in some other format?

-- 
M. Feldman

---

Vigil Health Solutions Inc.

www.vigil.com

Toll Free: 877-850-1122

Phone: 250-383-6900

Fax: 250-383-6999
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.data.SQLite documentation

2017-02-23 Thread Drago, William @ CSG - NARDA-MITEQ

> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of Mickey Feldman
> Sent: Thursday, February 23, 2017 7:46 AM
> To: sqlite-users@mailinglists.sqlite.org
> Subject: [sqlite] System.data.SQLite documentation
>
> I am not able to read SQLite.NET.chm, I see only the left hand panel, but not
> the expanded contents.  Is this a known issue, or perhaps an issue with
> Windows 7? Is this documentation available anywhere else or in some other
> format?
>
>

Did you unblock it? Right click on the file, select properties, then check the 
Unblock box.

--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l3t.com

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.

Effective immediately my new email address is william.dr...@l3t.com. Please 
update your records.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.data.SQLite documentation

2017-02-23 Thread Mickey Feldman

I am not able to read SQLite.NET.chm, I see only the left hand panel, 
but not the expanded contents.  Is this a known issue, or perhaps an 
issue with Windows 7? Is this documentation available anywhere else or 
in some other format?




--
M. Feldman

---

Vigil Health Solutions Inc.

www.vigil.com

Toll Free: 877-850-1122

Phone: 250-383-6900

Fax: 250-383-6999
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Segfault when inserting ascii text longer than max_length using python-Django

2017-02-23 Thread SASSOULAS Pierre 250112

Hi,

I encountered this segfault problem again and changed the django's database 
backend from sqlite3 to postgresql. Some errors started to show because of 
database constraints for maximum length of a string being checked and enforced 
by postrgresql (for example : "DataError: value too long for type character 
varying(255)") . Inserting a string longer than expected did not cause a 
segfault every time, but it did happen from time to time (See for example the 
minimal project to reproduce that I provided in a previous mail).

I hope this help.

Regards,


-Message d'origine-
De : drhsql...@gmail.com [mailto:drhsql...@gmail.com] De la part de Richard 
Hipp Envoyé : lundi 23 janvier 2017 14:25 À : SASSOULAS Pierre 250112 
 Objet : Re: [sqlite] Segfault when inserting ascii 
text using python-Django with Sqlite3

Apparently, a full Django install is required to reproduce the problem.  I do 
not have Django installed anywhere here, and really do not want to do so if not 
necessary.

Do you have some way of reproducing the problem without installing Django?

Can you provide us with a complete stack trace at the point of failure?

Can you retry using a more recent version of SQLite, such as 3.16.2?

On 1/23/17, SASSOULAS Pierre 250112  wrote:
> Here it is.
>
> I since found that replacing the migration file in myapp/migrations 
> with "python manage.py makemigrations" makes the segfault disappear 
> (for the sanded down version at least). Maybe something to consider 
> during troubleshooting ?
>
> Regards
>
> -Message d'origine-
> De : drhsql...@gmail.com [mailto:drhsql...@gmail.com] De la part de 
> Richard Hipp Envoyé : samedi 21 janvier 2017 16:11 À : SASSOULAS 
> Pierre 250112  Objet : Re: [sqlite] Segfault 
> when inserting ascii text using python-Django with Sqlite3
>
> This mailing list strips attachments.  Please send the attachment via 
> private email directly to me.
>
> On 1/20/17, SASSOULAS Pierre 250112  wrote:
>> Hi,
>>
>> I've encountered a segfault in a python-django project when inserting 
>> seemingly random innocent looking data into an sqlite3 databse. It 
>> happen while testing a custom command in Django unit-test.
>>
>> Version :
>> python --version
>> Python 2.7.12
>>
>> sqlite3 --version
>> 3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f
>>
>> pip freeze
>> Django==1.10.5
>>
>> Here's the error in gdb :
>>
>> gdb python
>> (gdb) run manage.py test
>> Starting program:
>> /home/user/workspace/sqlitesegfaultbug/.env/bin/python
>> manage.py test
>>
>> Program received signal SIGSEGV, Segmentation fault.
>> 0x74545ad8 in ?? () from
>> /usr/lib/x86_64-linux-gnu/libsqlite3.so.0
>>
>> The bug happened specifically for a String between "Sonde de platine"
>> and "Thermohygromètre" initially. I enclosed a sanded down django 
>> project in case you want to reproduce. The problem happen on another 
>> string, but I don't think that a particular string is the problem.
>> There is logging in place that could help diagnose the problem.
>>
>> Step to reproduce once the project is unzipped :
>> virtualenv .env
>> source .env/bin/activate
>> pip install --upgrade pip
>> pip install --requirement=requirements.txt
>> python manage.py test
>>
>> Thank in advance and thank you for the time you already invested in 
>> sqlite,
>>
>> Regards,
>>
>> Pierre Sassoulas
>> ___
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
>


--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite.Interop.dll

Re: [sqlite] SQLite.Interop.dll

Re: [sqlite] System.data.SQLite documentation

Re: [sqlite] System.data.SQLite documentation

[sqlite] System.data.SQLite documentation

Re: [sqlite] Segfault when inserting ascii text longer than max_length using python-Django

6 matches

Site Navigation

Mail list logo

Footer information