Re: [sqlite] SQLite.Interop.dll
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 Eisenbeiswrote: > > --- > 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
--- 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
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 FeldmanDate: 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
> -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
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
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 250112Objet : 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