Re: [sqlite] system.data.sqlite example code?

I think this is an informative post and knowledgeable. I would like to thank you for the efforts you have made in writing this article Packers and Movers in Delhi - [url=https://www.aryawartapackers.com]packers and movers in delhi[/url] -- Sent from: http

Re: [sqlite] System.Data.SQLite Verson 111

I found the version 111 but it is still not working. I assume the problem is with the latest Visual Studio 2017 version. Earlier versions worked.   I installed Visual Studio 2015 Community. I made a test project.   EF 6.3 I couldn't correctly install because of an msbuild error. No idea what the

Re: [sqlite] system.data.sqlite example code?

Nice to see about the information here, thanks for sharing https://trainsrunningstatus.live -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mai

Re: [sqlite] system.data.sqlite example code?

Thanks for your post, If you want to know more about Programming or want Programming Help , We are here 24*7 - [url=https://www.greatassignmenthelp.com/programming-assignment-help]Programming Help[/url] -- Sent from: http:

Re: [sqlite] System.Data.SQLite version 1.0.108 - .NET 2.0 no service pack compatibility

It may work without Service Pack 2; however, it has not been tested in that configuration. Sent from my iPhone > On Jun 20, 2018, at 7:45 AM, Bianchi Lorenzo > wrote: > > Hi everybody, > > We are currently using the SQlite.dll version 1.0.98 x86 for .NET 2.0, and it > seems to be working a

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 Feldman Date: 23/02/2017 12:45 (GMT+00:00) To: sqlite

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

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

Thanks, Jens. I'll keep an eye on that. Take care, Melody -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke Sent: Monday, December 12, 2016 12:32 PM To: SQLite mailing list Subject: Re: [sqlite] System.Data.S

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

> On Dec 12, 2016, at 5:00 AM, Baugher, Melody wrote: > > string passwordPragma = "PRAGMA key='" + password + "';"; Not quoting the password string leaves you open to SQL injection attack. This probably isn’t an issue in an internal development tool, but if there’s any code like this in

Re: [sqlite] System.Data.SQLite -> ChangePassword 2nd time has opposite behavior

On 12 Dec 2016, at 1:00pm, Baugher, Melody wrote: > Starting with an encrypted database, if I run this code twice in a row with > applyPassword=false, the password is removed the first time but then applied > the second time. Your program is weird and buggy. There is one big test in the prog

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

A follow-up on this (and a late thanks!): I've used your answer to write some build instructions for Ubuntu and Raspbian at http://blog.wezeku.com/2016/10/09/using-system-data-sqlite-under-linux-and-mono/ I've also modified the F# SQLProvider type provider so that it no longer always loads Mono

Re: [sqlite] [System.Data.SQLite] Using sqlite3.dll instead of Interop.dll - what's the trade-off?

John Reynolds wrote: > > My question is: what are the trade-offs of not using > SQLite.Interop.dll? > There are various compile-options and extensions baked into the "SQLite.Interop.dll" that are not enabled and/or included by default with "sqlite3.dll". One that is somewhat important, is the

Re: [sqlite] System.Data.SQLite

Through DBContext constructor I have associated the connection. As the table is not existing in my database, it throws an exception. Does sqlite support automatic creation of tables or do I have create the tables and relationships first and then insert the data using the framework? On Fri, Aug 19

Re: [sqlite] [System.Data.SQLite] Nuget 3 support

Jann Roder wrote: > > Nuget 3 now seems to have much better support for native libraries. > I'd really like to use this for System.Data.SQLite. I suspect this will require a great deal of investigation, refactoring, and debugging. It's too late in the release cycle for 1.0.102.0 for this. I'll

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

OK. Embarassing as it is, I'm going to have to 'fess up here. When I attempted to implement a stopwatch which wasn't available, I discovered that the app was targetting .Net 2. When I rebuilt it targetting 3.5 it worked. Unfortunately the stopwatch tells me that it takes longer than I would like (

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Duncan Hall wrote: > > I'm not using the Spatialite extension for the query, only the indexes > created by it on the desktop which I think is a pretty standard SQLite > RTree. At least it works that way on the desktop. > So, on the target device, only the System.Data.SQLite binaries are being us

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

> Thanks. I've run the schema and query here with the desktop version of > SpatiaLite and it does not crash. I suspect the underlying issue may be > an alignment fault (or stack overflow) due to bad interaction between the > ARM processor architecture and the SpatiaLite extension. I'm not using

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Duncan Hall wrote: > > The db was created by Spatialite and has a fairly lengthy schema. I'm not > sure if I should leave anything out so I'll attach a text file. > Thanks. I've run the schema and query here with the desktop version of SpatiaLite and it does not crash. I suspect the underlying

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Joe Mistachkin-3 wrote > Are you able to share the schema for your database? It may be helpful. The db was created by Spatialite and has a fairly lengthy schema. I'm not sure if I should leave anything out so I'll attach a text file. schema.txt

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Duncan Hall wrote: > > 'cmd.CommandText = "SELECT name FROM sqlite_master WHERE type='table'" > cmd.CommandText = "SELECT * FROM idx_Locale_Geometry " > Are you able to share the schema for your database? It may be helpful. -- Joe Mistachkin ___ sqli

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Thanks for the response I'm developing for a Mobile 5 or 6 device in Visual Studio 2008. I'm porting a project that works fine on the desktop in VS 2012. I have tried the most recent release 1.094 and also 1.095 pre release. I also tried with an old version 1.082 which is working in another app, b

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Green Fields wrote: > > I realise that Windows Mobile 6 is not well supported any more, but can > anyone help with some insight of what may be causing this to occur on the > Mobile and not the desktop? > It is supported. However, I've been unable to reproduce the issue that you describe here lo

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Hi I have investigated this problem further and it appears that RTree is definitely enabled, most queries work fine, but a query to the index fails. I have tried a straight query to the index SELECT * FROM idxNetwork WHERE ROWID = 1, which fails crashing the app at command.ExecuteReader()

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

lite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Stephen Chrzanowski Sent: Friday, January 23, 2015 1:07 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable In the 8.3 days, I routinely g

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

gt;From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >boun...@sqlite.org] On Behalf Of Hick Gunter > >Sent: Thursday, 22 January, 2015 01:39 > >To: 'General Discussion of SQLite Database' > >Subject: Re: [sqlite] System.Data.SQLite - Exception Calling &

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

sday, 22 January, 2015 01:39 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] System.Data.SQLite - Exception Calling >SQLiteModule.DeclareTable > >I have always wondered why people will insist on using human readable >column names (with embedded spaces and

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

etreff: Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable Figured this one out. DeclareTable doesn't like any 'quoting' around the column names in the sql. It works fine with just straight column names. -Original Message- From: sqlite

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

Figured this one out. DeclareTable doesn't like any 'quoting' around the column names in the sql. It works fine with just straight column names. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mike Nicolino Sent: Saturday,

Re: [sqlite] System.Data.Sqlite, not using parameterized query, how to encode special characters

On 16 Jan 2015, at 7:06pm, Andy (KU7T) wrote: > If I just build the sql string myself, how can I solve encoding > issues as mentioned above? There's only one character which should cause a problem with embedded strings: the apostrophe. And you escape this by doubling it. Illustration: INSER

Re: [sqlite] System.Data.SQLite (v1.0.94.0) - Which encryptionalgorithm is used?

Krenn Christoph wrote: > > However I would like to know which encryption algorithm is used by > System.Data.SQLite, v1.0.94.0? > The legacy encryption support in System.Data.SQLite uses the CryptoAPI with the constants PROV_RSA_FULL and MS_ENHANCED_PROV, as described here: http://msdn.

Re: [sqlite] System.Data.SQLite NuGet

Michael Quinlan wrote: > > The current NuGet package seems to include SQLite version 3.8.6. Are there > plans to update to version 3.8.7? > The core NuGet packages contain the SQLite core library code, customized for use with System.Data.SQLite (i.e. commonly referred to as the "SQLite interop

Re: [sqlite] System.Data.SQLite - issues

Chris Abbott wrote: > > I've also noticed a drastic degradation in speed with this release over > 1.0.86. > This issue should be fixed in 1.0.94.0. Please try with the pre-release bits available at: https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki -- Joe

Re: [sqlite] System.Data.SQLite - issues

writes: > > Hi, > Below are the two issues I would like to report for SQLite .Net client. > 1. SQLiteDataReader.GetString() method: > The method fails with "Invalid cast exception" when you try to retrieve a number stored in a text field. > > 2. SQLiteDataReader.GetValue performance in versio

Re: [sqlite] System.Data.Sqlite

On Tue, Jul 29, 2014 at 4:48 AM, Clemens Ladisch wrote: > > Simplified for plain ol' SQLite as follows: > Thank you. That is exactly what we needed. The bug has now been characterized, studied, and fixed. See [ http://www.sqlite.org/src/info/d2889096e7bdeac6] for the ticket and [ http://www.s

Re: [sqlite] System.Data.Sqlite

di 29 juillet 2014 10:49 À : sqlite-users@sqlite.org Objet : Re: [sqlite] System.Data.Sqlite Eric DAVID wrote: > Well, It seems to be impossible to join files to mails. So, here are > the statements : > > CREATE TABLE Lignes (lig_id INTEGER PRIMARY KEY AUTOINCREMENT NOT > NULL, l

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > Well, It seems to be impossible to join files to mails. So, here are the > statements : > > CREATE TABLE Lignes (lig_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, > lig_nom TEXT NOT NULL); > SELECT AddGeometryColumn('Lignes', 'lig_geom', 2154, 'LINESTRING', 'XY'); > ... Simpl

Re: [sqlite] System.Data.Sqlite

On 29 Jul 2014, at 12:43am, Eric DAVID wrote: > Well, It seems to be impossible to join files to mails. So, here are the > statements : Unfortunate I'm not willing to download SpatiaLite just to test this. But I'm still suspecting that the problem is in your high-precision numbers. Simon. __

Re: [sqlite] System.Data.Sqlite

T(916928.18227 6510219.970372)', 2154)); INSERT INTO Pylones VALUES (NULL, 2, '3', GeomFromText('POINT(917674.889861 6509913.815551)', 2154)); INSERT INTO Pylones VALUES (NULL, 2, '4', GeomFromText('POINT(918338.55431 6510407.669698)', 2154)); -Message d'

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > > Here is the list of all sql statements in the file Base.sql, included > INSERT Statements. > Unfortunately, the mailing list strips most attachments. Can you include the information within the message itself? -- Joe Mistachkin __

Re: [sqlite] System.Data.Sqlite

chkin Envoyé : lundi 28 juillet 2014 23:59 À : 'General Discussion of SQLite Database' Objet : Re: [sqlite] System.Data.Sqlite Eric DAVID wrote: > > Yes, it is this one. With the new script I gave in my last mail it has > changed to > > SELECT * FROM Pylones P > JOI

Re: [sqlite] System.Data.Sqlite

> On 28 Jul 2014, at 10:58pm, Joe Mistachkin wrote: > > Eric DAVID wrote: > >> Yes, it is this one. With the new script I gave in my last mail it has >> changed to >> >> SELECT * FROM Pylones P >> JOIN Lignes L ON L.lig_id = P.lig_id >> JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > > Yes, it is this one. With the new script I gave in my last mail it has > changed to > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 1; > So far, I'm unable to reproduce your results here

Re: [sqlite] System.Data.Sqlite

23:11 À : 'General Discussion of SQLite Database' Objet : Re: [sqlite] System.Data.Sqlite Eric DAVID wrote: > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 3; > Is the above query the on

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P.pyl_id = I.pkid WHERE L.lig_id = 3; > Is the above query the one that has the issue? What is the output you expect from it? -- Joe Mistachkin ___

Re: [sqlite] System.Data.Sqlite

On 28 Jul 2014, at 5:51pm, Eric DAVID wrote: > You are right, your example works correctly. > I created my database again with the script below and I tried some changes. > The error still occurs with System.Data.Sqlite 3.8.5. If I drop the index > idx_Pylones_lig_id, the results are good again.

Re: [sqlite] System.Data.Sqlite

916928.18227 6510219.970372)', 2154)); INSERT INTO Pylones VALUES (NULL, 2, '3', GeomFromText('POINT(917674.889861 6509913.815551)', 2154)); INSERT INTO Pylones VALUES (NULL, 2, '4', GeomFromText('POINT(918338.55431 6510407.669698)', 2154)); - -

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > But this one gives correct results only with Spatialite GUI (Sqlite version > 3.7.3) or QGIS (Sqlite version 3.7.17) but wrong results with > System.Data.Sqlite (version 3.8.5). > > SELECT * FROM Pylones P > JOIN Lignes L ON L.lig_id = P.lig_id > JOIN idx_Pylones_pyl_geom I ON P

Re: [sqlite] System.Data.Sqlite

rg [mailto:sqlite-users-boun...@sqlite.org] De la part de Simon Slavin Envoyé : lundi 28 juillet 2014 15:43 À : General Discussion of SQLite Database Objet : Re: [sqlite] System.Data.Sqlite On 28 Jul 2014, at 1:01pm, Eric DAVID wrote: > I have a problem using System.Data.Sqlite in a C# appl

Re: [sqlite] System.Data.Sqlite

On 28 Jul 2014, at 1:01pm, Eric DAVID wrote: > I have a problem using System.Data.Sqlite in a C# application. I have 2 > tables, each table with a geometry field and a spatial index, so the > following request give me the results I want using Spatialite GUI or QGIS : > > > > SELECT * FROM Pyl

Re: [sqlite] System.Data.SQLite - issues

Manish Kukreti wrote: > > 1. SQLiteDataReader.GetString() method: > The method fails with "Invalid cast exception" when you try to retrieve > a number stored in a text field. > Do you have some example C# code and/or a database schema that demonstrates this issue? What is the declared data typ

Re: [sqlite] System.Data.SQLite failing in Windows 7

on of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite failing in Windows 7 Calvert, Jim wrote: > > Is there anybody from the developers of SQLite who can comment on this issue > for me. > I did reply to your original post. Here is a link to the thread: http:

Re: [sqlite] System.Data.SQLite failing in Windows 7

logs. - Akintoye From: jwcalv...@rogers.com At: Jun 13 2014 14:22:16 To: jwcalv...@rogers.com, sqlite-users@sqlite.org Subject: Re: [sqlite] System.Data.SQLite failing in Windows 7 Everyone, Is there anybody from the developers of SQLite who can comment on this issue for me. Thanks

Re: [sqlite] System.Data.SQLite failing in Windows 7

Calvert, Jim wrote: > > Is there anybody from the developers of SQLite who can comment on this issue > for me. > I did reply to your original post. Here is a link to the thread: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg84247.html -- Joe Mistachkin __

Re: [sqlite] System.Data.SQLite failing in Windows 7

> On 13 Jun 2014, at 7:22pm, Calvert, Jim wrote: > > Is there anybody from the developers of SQLite who can comment on this issue > for me. We saw your post. No need to repeat it. Your problem is not with SQLite and that's why we didn't answer. Consult whoever wrote your MS Outlook synchron

Re: [sqlite] System.Data.SQLite failing in Windows 7

Everyone, Is there anybody from the developers of SQLite who can comment on this issue for me. Thanks -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Calvert, Jim Sent: June 12, 2014 11:46 PM To: sqlite-users@sqlite.org Subje

Re: [sqlite] System.Data.SQLite failing in Windows 7

Calvert, Jim wrote: > > "Could not load file or assembly 'System.Data.SQLite, Version=1.0.66.0, > > Culture neutral, PublicKeyToken=db937bc2d44ff139' or one of its > dependencies. > > The module was expected to contain assembly manifest." > I have not seen that error before; however there may

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

any kind of error. ** After these changes I was able to compile the project. /Mattias From: Eric Johnston To: General Discussion of SQLite Database Date: 2014-05-13 18:19 Subject:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

rg Sent: 13 May, 2014 05:07 To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 I finally managed to build SQLite using help from the following thread: http://sqlite.1065341.n5.nabble.com/Building-SQLite-on-Windows-Embedded-Compact-7-WEC7

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

:Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org I have found versions of the download page where ARM wasn't mentioned, e.g. http://system.data.sqlite.org/index.html/artifact/99229e8a9f2b261771735c32de22ae025292c01a . I th

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

n To: General Discussion of SQLite Database Date: 2014-05-09 17:45 Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org It must have been, considering other software running on these WinCE 6 devices I have are usi

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

any chance? -- Eric -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mattias Kindborg Sent: 9 May, 2014 06:03 To: General Discussion of SQLite Database Subject: Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Hi Eri

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5 Sent by:sqlite-users-boun...@sqlite.org Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year

Re: [sqlite] System.Data.SQLite on Windows CE x86 with .NET3.5

Among the binaries all I see is for .NET Compact Framework 3.9 (the latest from Microsoft, but not supported prior to their collection of operating systems that were released last year, so it doesn't work with WinCE 6). I have compiled for ARM with .NET CF 3.5 in VS2008, but not x86. -- Eric >

Re: [sqlite] System.Data.SQLite Deployment Mystery

Dear Joe, Thank you for your helpful comments. I’ve finally got it going on ‘naïve’ Win 8 (and Win 7) computers, but I don’t 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 s

Re: [sqlite] System.Data.SQLite Deployment Mystery

Dear Markus, Thank you for your helpful comments. I’ve finally got it going on ‘naïve’ Win 8 (and Win 7) computers, but I don’t understand why!! In short, I got it going by adopting the technique described here: http://rashimuddin.wordpress.com/tag/sqlite-interop-dll/ Perhaps you ca

Re: [sqlite] System.Data.SQLite Deployment Mystery

Hi, Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > > 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

Re: [sqlite] System.Data.SQLite Deployment Mystery

: '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 > instal

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:

Re: [sqlite] System.Data.SQLite Deployment Mystery

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. -- View this message in context: http://sqlite.1065341.n5.nabble.com/System-Data-SQLite-Deployment-Mys

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

nstalled 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] Syste

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

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

nesday, 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- Fr

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

On 26 Feb 2014, at 2:15pm, Incongruous wrote: > You've sparked my curiosity, what is this VEE programming language? Hope this helps

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] Sys

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

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

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

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 c

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

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 lik

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 proce

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!

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

Re: [sqlite] System.Data.SQLite documentation

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.Da

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/fa

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Eric Schultz wrote: > > The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! > Any plan for when the final will be out? > The release is currently scheduled for Monday, February 10th (give or take a day or so). -- Joe Mistachkin __

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Joe, The 1.0.91.0 beta you gave me works perfect in my scenario. Thanks so much! Any plan for when the final will be out? Eric On Mon, Feb 3, 2014 at 3:12 PM, Joe Mistachkin wrote: > > Eric Schultz wrote: > > > > I can't seem to build the Interop.SQLite.dll files ("build.bat > > ReleaseNative

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Eric Schultz wrote: > > I can't seem to build the Interop.SQLite.dll files ("build.bat > ReleaseNativeOnly Win32" fails due to a missing stdarg.h file). > What version of Visual Studio and/or MSBuild are you using? Are you able to build other MSVC projects in your environment? Anyhow, I've crea

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Joe, I can't seem to build the Interop.SQLite.dll files ("build.bat ReleaseNativeOnly Win32" fails due to a missing stdarg.h file). That said, using the previous Interop.SQLite.dll files, I no longer get a DLLNotFoundException but an 'EntryPointNotFoundException' with the message of "Unable to fi

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Eric Schultz wrote: > > One thing I did notice when debugging is that on these copied assemblies, > the Assembly.CodeBase property has the original location of the Assembly > before running. > I've added code to the native library pre-loader to attempt to handle using the code base of the ass

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

I suppose I could set the environment variables but that feels... funky since they apply to the user as a whole. One thing I did notice when debugging is that on these copied assemblies, the Assembly.CodeBase property has the original location of the Assembly before running. I'm guessing this is w

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

I'm not a ".net" guy but, I do use visual studio. One thing I do is have several post-build steps that copy files around to where I need them before I debug. You can define "post build" steps in the project options. Thursday, January 30, 2014, 7:16:55 PM, you wrote: JM> Eric Schultz wrote

Re: [sqlite] System.Data.SQLite Preloading and ASP.Net debugging

Eric Schultz wrote: > > When I debug in Visual Studio, IIS Express copies all of the > Assemblies in my "bin" directory to a folder into the "AppData\Temporary > ASP.Net Files" folder. Unfortunately, it does not copy the > System.Data.SQLite.dll.config file or the x86 and amd64 subfolders of bin >

Re: [sqlite] System.Data.SQLite - System.MissingMethodException was unhandled

On 1/23/2014 15:08, Joe Mistachkin wrote: I have no idea what would cause 1.0.87.0 to stop working when it was working before. Has anything about the device itself or operating system changed? I can't rule it out, but I've not done anything with the device or the code since before the holida

Re: [sqlite] System.Data.SQLite - System.MissingMethodException was unhandled

Bo Gusman wrote: > > In my simple test project, it is failing when attempting to open the > connection. The same is true in the larger project with the 0.87 version > that has been working for months (and is now failing). > The 1.0.87.0 and 1.0.90.0 releases for the .NET Compact Framework sh

Re: [sqlite] System.Data.SQLite - System.MissingMethodException was unhandled

Thanks for the reply, Joe. I truly appreciate it. On 1/23/2014 13:47, Joe Mistachkin wrote: Bo Gusman wrote: System.MissingMethodException was unhandled Message="Could not load type 'System.Data.SQLite.SQLiteConnection' from assembly 'System.Data.SQLite, Version=1.0.90.0, Culture=neutral,

Re: [sqlite] System.Data.SQLite - System.MissingMethodException was unhandled

Bo Gusman wrote: > > System.MissingMethodException was unhandled >Message="Could not load type 'System.Data.SQLite.SQLiteConnection' > from assembly 'System.Data.SQLite, Version=1.0.90.0, Culture=neutral, > PublicKeyToken=1FDB50B1B62B4C84'." > What method is it trying to call at that poi

Re: [sqlite] [System.Data.SQLite] Load spatialite-extension throughSystem.Data.SQLite

Markus Dibo wrote: > > Other users seem to have the same problem: > https://groups.google.com/forum/#!topic/spatialite-users/fOb_J8djVP4 > It appears that the issue also appears in a completely different ADO.NET provider for SQLite. Also, people report that it does not appear with the previou

Re: [sqlite] System.Data.SQLite and UNC Paths

Denis Burke wrote: > > All versions of System.Data.SQLite beyond 1.0.85 (including 1.0.89) fail > when I try to open a DB using a UNC path. The error I see is that the > database cannot be read. > Due to the newly revised connection string parsing algorithm (which was revised to fix other issues

Re: [sqlite] System.Data.SQLite version 1.0.89.0 released

Jan Slodicka wrote: > > bool exists; > exists = idxs.TryGetValue("Abc", out i);// true => ok > exists = idxs.TryGetValue("abc", out i);// false => BUG > Thanks, fixed on trunk. SQLiteDataReader now uses the built-in StringComparer class instead. -- Joe Mistachkin __

Re: [sqlite] System.Data.SQLite version 1.0.89.0 released

This looks like a bug (ColumnNameComparer is taken from SqliteDataReader 1.0.89): var idxs = new Dictionary(new ColumnNameComparer()); idxs.Add("Xyz", 1); idxs.Add("Abc", 2); bool exists; exists = idxs.TryGetValue("Abc", out i);// true => ok exists = idxs.TryGetValue("abc", out i);

Re: [sqlite] System.Data.SQLite version 1.0.89.0 released

>> 2) SqliteDataReader.GetOrdinal() > This does not appear to be entirely compatible, most notable due to not > taking the keyInfo into account. Sorry, I forgot that we eliminated all keyInfo-related code. Anyway, it still would make sense to extend caching to all column names that were visite

Re: [sqlite] System.Data.SQLite version 1.0.89.0 released

Jan Slodicka wrote: > > I have couple of small perf tips. > > 1) SQLite3.GetValue(SqliteStatement stmt, int index, SQLiteType typ) > > Starts with this code: > if (IsNull(stmt, index)) return DBNull.Value; > I've adjusted the method to take advantage of the known affinity, here: h

  1   2   3   >