Re: [sqlite] SQLite.NET Class Library Documentation Feedback: Limitations

> On Oct 5, 2016, at 5:49 AM, Santiago Bayeta wrote: > > But I also read from SQLite docs that now SQLite supports unlimited Reading > operations while writing. It does if the databases uses a WAL (Write-Ahead Log). This is a persistent per-database setting that can be

Re: [sqlite] sqlite.net (a.k.a. System.Data.SQLite) support

You are using the straight SQLite classes to execute commands and such. Why not use EF6 and use SQLite as a data source. All the visual studio stuff works with it just the same a SQL server. If you can use .Net 4.0 or 4.5 then that is the way to go. You can use the EF 6 entity diagrams to

Re: [sqlite] [SQLite.NET] Cannot read BLOB data

: Re: [sqlite] [SQLite.NET] Cannot read BLOB data Kevin Keigwin wrote: > > I cannot read the data into a DataTable using the adapter, because the > exception "Invalid storage type: DBNull." is thrown. > There was a recently fixed issue with the SQLiteDataAdapter class. Th

Re: [sqlite] [SQLite.NET] Cannot read BLOB data

Kevin Keigwin wrote: > > I cannot read the data into a DataTable using the adapter, because the > exception "Invalid storage type: DBNull." is thrown. > There was a recently fixed issue with the SQLiteDataAdapter class. The fix can be seen here:

Re: [sqlite] [SQLite.net] DateTime exception when reading

On Wed, 22 May 2013 12:23:12 -0700 "Kevin Keigwin" wrote: > What I don't understand is why the database is so forgiving of dates > being saved, while the SQLiteDataAdapter isn't. As Simon said, "SQLite doesn't have a DateTime type." As far as SQLite is concerned, your

Re: [sqlite] [SQLite.net] DateTime exception when reading

On 22 May 2013, at 8:23pm, "Kevin Keigwin" wrote: > And I've discovered the source of the problem by downloading the source code > and debugging the SQLiteDataAdapter. I had created some test data through > the GUI tool and entered a non-ISO8601 date string. Because

Re: [sqlite] [SQLite.net] DateTime exception when reading

>Can you try the other stuff I wrote ? We don't yet have enough information to figure out what's going wrong. >Simon. Sorry, Simon. I missed what else you wrote because it was embedded in my original email text. My error. And I've discovered the source of the problem by downloading the

Re: [sqlite] [SQLite.net] DateTime exception when reading

On 22 May 2013, at 7:59pm, Kevin Keigwin wrote: > I understand. Can you try the other stuff I wrote ? We don't yet have enough information to figure out what's going wrong. Simon. ___ sqlite-users mailing list

Re: [sqlite] [SQLite.net] DateTime exception when reading

>SQLite doesn't have a DateTime type. If you are using some sort of library which does type testing and produces an error if the value is of >the wrong type, it will always produce an error message when checking for DateTime. >Simon. I understand. As I said in my post, the underlying type of

Re: [sqlite] [SQLite.net] DateTime exception when reading

On 22 May 2013, at 5:47pm, "Kevin Keigwin" wrote: > When our code tries to execute "SELECT * FROM ORDER by > .id", I get the exception "String was not recognized as a valid > DateTime". Use your code to populate your database but don't worry about a SELECT command.

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Fri, 19 Apr 2013 16:41:53 -0700, "Joe Mistachkin" wrote: >Actually, ALL the non-static packages on the download page require the MSVC >runtime libraries of the appropriate version to be installed. > >The download page does mention these requirements in each applicable

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Gilles Ganault wrote: > > Got it: "Dependency Walker" shows that the (no-)bundle versions rely > on MSVCR110.DLL, which is part of the "Visual C++ Redistributable for > Visual Studio 2012 Update 1", available here: > > www.microsoft.com/en-us/download/details.aspx?id=30679 > > Once installed,

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Fri, 19 Apr 2013 23:42:19 +0200, Gilles Ganault wrote: >Thanks the tip. More testing in the IDE shows that it works OK even >when editing the PATH, and I can no longer trigger the "Unable to >load DLL 'SQLite.Interop.dll': The specified module could not be >found.

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 23:46:58 -0400, markus diersbock wrote: >Since it worked, you can move the files to any final folder, and add a >reference to System.Data.SQLite.dll > >And add your folder to PATH, to find SQLite.Interop.dll Thanks the tip. More testing in the IDE shows

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Putting them in your /debug folder was just to troubleshoot. Since it worked, you can move the files to any final folder, and add a reference to System.Data.SQLite.dll And add your folder to PATH, to find SQLite.Interop.dll For the end-user you can keep it simple and put the files in the same

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 13:36:54 -0400, markus diersbock wrote: >Put SQLite.Interop.dll in the same folder as your VB assembly (ie >/debug or /release) Thanks for the tip. But it's kind of a pain to have to copy SQLite.Interop.dll + System.Data.SQLite.dll in \debug with every

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Sorry... replied to the wrong message. :( -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Marc L. Allen Sent: Thursday, April 18, 2013 1:40 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] [SQLite.Net] Right

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Subject: Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries? Put SQLite.Interop.dll in the same folder as your VB assembly (ie /debug or /release) On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault <gilles.gana...@free.fr> wrote: > Hello, > > I'm having a problem get

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

Put SQLite.Interop.dll in the same folder as your VB assembly (ie /debug or /release) On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote: > Hello, > > I'm having a problem getting VB Express to find SQLite .Net: > > 1. I went to... >

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 16:10:48 +0200, Gilles Ganault wrote: >It did work finally by using > >sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip I wanted to edit the FAQ to spare other newbies, but even after logging on as "anonymous" and typing the one-time

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

It doesn't work either with sqlite-netFx45-binary-bundle-Win32-2012-1.0.84.0.zip whether System.Data.SQLite.dll is located in .\Externals or some other location. It did work finally by using sqlite-netFx45-static-binary-bundle-Win32-2012-1.0.84.0.zip Could it be due to VC++ dependency?

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 15:32:02 +0200, Gilles Ganault wrote: >Does it mean that we have to copy the two files in each and every >application, instead of just putting them in eg. C:\Windows? Still no go. 1. Per the FAQ

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

On Thu, 18 Apr 2013 09:27:00 -0400, Kevin Benson wrote: >http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html Thanks. "In order for this to work successfully, it must be able to locate that file at runtime, which means the

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html -- -- -- --Ô¿Ô-- K e V i N On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote: > Hello, > > I'm having a problem getting VB Express to find SQLite .Net: > > 1.

Re: [sqlite] sqlite.net build problems

check the target CPU, if not x86, will probably fail. On Fri, Jun 8, 2012 at 12:37 AM, netra wrote: > Hi, > > > Hope you could help me immediate on this issue. > I am using System.Data.SQLite.DLL (version 1.0.66.0) but when i am adding to > WPF setup i am unable to see this

Re: [sqlite] sqlite.net download file

majorthorb...@mst-it-services.info wrote: > > C:\Program Files\System.Data.SQLite\2010\GAC>"..\..\..\microsoft > sdks\windows\v7 > .1\bin\gacutil" /i System.Data.SQLite.dll > Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1 > Copyright (c) Microsoft Corporation. All rights

Re: [sqlite] sqlite.net download file

Installed latest SDK (7.1) and reran the command and got the following: C:\Program Files\System.Data.SQLite\2010\GAC>"..\..\..\microsoft sdks\windows\v7 .1\bin\gacutil" /i System.Data.SQLite.dll Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1 Copyright (c) Microsoft

Re: [sqlite] sqlite.net download file

> > majorthorb...@mst-it-services.info wrote: >> >> I have tried to install sqlite from what I thought were the correct >> files >> > > Which files are you referring to? What site did you download them from? > sqlite-netFx40-setup-bundle-x64-2010-1.0.77.0.exe from system.data.sqlite.org

Re: [sqlite] sqlite.net download file

majorthorb...@mst-it-services.info wrote: > > I have tried to install sqlite from what I thought were the correct files > Which files are you referring to? What site did you download them from? > > but have not managed to find the sqlite.net folder that the help file > mentions as support for

RE: [sqlite] SQLite.Net

sqlite.org Subject: Re: [sqlite] SQLite.Net On 20.09.2007 15:06 CE(S)T, Samuel R. Neff wrote: > can you be more specific? Thread links.. http://sqlite.phxsoftware.com/forums/t/731.aspx "SQLiteDataReader.GetValue() not returning DateTime" http://sqlite.phxsoftware.com/forums/t/79

Re: [sqlite] SQLite.Net

On 20.09.2007 15:06 CE(S)T, Samuel R. Neff wrote: > can you be more specific? Thread links.. http://sqlite.phxsoftware.com/forums/t/731.aspx "SQLiteDataReader.GetValue() not returning DateTime" http://sqlite.phxsoftware.com/forums/t/795.aspx "Cannot retrieve data from a column; inconsistent

RE: [sqlite] SQLite.Net

is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Yves Goergen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 8:34 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite.Net On 19.09.2007 17:54 CE(S)T, Samuel R. Neff wrote

Re: [sqlite] SQLite.Net

On 19.09.2007 17:54 CE(S)T, Samuel R. Neff wrote: > However, I do use the one Robert suggested heavily > and can attest to the fact that it is extremely well written and works > without errors. Ehm, wait, I know of two bugs that have been reported in their forum and were not even replied to for

RE: [sqlite] SQLite.Net

E: [sqlite] SQLite.Net Ok, but why I can't use this wrapper http://www.phpguru.org/static/SQLite.NET.html ? -Message d'origine- De : Robert Simpson [mailto:[EMAIL PROTECTED] Envoyé : mercredi 19 septembre 2007 17:16 À : sqlite-users@sqlite.org Objet : RE: [sqlite] SQLite.Net And for g

RE: [sqlite] SQLite.Net

ichael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 8:29 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQLite.Net > > Ok, but why I can't use this wrapper > http://www.phpguru.org/static/SQLite.NET.html ? > > > -Message d'o

RE: [sqlite] SQLite.Net

Ok, but why I can't use this wrapper http://www.phpguru.org/static/SQLite.NET.html ? -Message d'origine- De : Robert Simpson [mailto:[EMAIL PROTECTED] Envoyé : mercredi 19 septembre 2007 17:16 À : sqlite-users@sqlite.org Objet : RE: [sqlite] SQLite.Net And for good reason ... Adapting

RE: [sqlite] SQLite.Net

And for good reason ... Adapting the sqlite3 api to .NET is not trivial. > -Original Message- > From: Michael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 8:09 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQLite.Net > >

RE: [sqlite] SQLite.Net

lto:[EMAIL PROTECTED] Envoyé : mercredi 19 septembre 2007 17:00 À : sqlite-users@sqlite.org Objet : RE: [sqlite] SQLite.Net If you're using the Finisar library, it doesn't work with the later sqlite3 libraries. If you're using the PHP one, it hasn't been updated in almost 3 years so it probably

RE: [sqlite] SQLite.Net

> -Original Message- > From: Michael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 7:42 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] SQLite.Net > > SQLite.NET.2.0.1 > > -Message d'origine- > De : Robert Simpson [mail

RE: [sqlite] SQLite.Net

SQLite.NET.2.0.1 -Message d'origine- De : Robert Simpson [mailto:[EMAIL PROTECTED] Envoyé : mercredi 19 septembre 2007 16:31 À : sqlite-users@sqlite.org Objet : RE: [sqlite] SQLite.Net What .NET wrapper are you using? > -Original Message- > From: Michael Martin [mailto:

RE: [sqlite] SQLite.Net

What .NET wrapper are you using? > -Original Message- > From: Michael Martin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 7:13 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite.Net > > Hi all, > > > > I try to use SQLite (sqlite3.dll) in DotNet; this

Re: [sqlite] SQLite.NET in-memory database creation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brass Tilde wrote: >>>Stupid question, but how can i create an in-memory database with >>>SQLite.NET provider? When i use Data Source=:memory: i get an exception >>>that the specified file isn't found. >> >>If you are using the ADOSQLiteDotNet

Re: [sqlite] SQLite.NET in-memory database creation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter Berkenbosch wrote: > Stupid question, but how can i create an in-memory database with > SQLite.NET provider? When i use Data Source=:memory: i get an exception > that the specified file isn't found. > > Can anyone explain to me how it is done ?

Re: [sqlite] SQLite.NET in-memory database creation

> > Stupid question, but how can i create an in-memory database with > > SQLite.NET provider? When i use Data Source=:memory: i get an exception > > that the specified file isn't found. > > If you are using the ADOSQLiteDotNet provider from SourceForge, add > "New=True" > to your connection

Re: [sqlite] SQLite.NET in-memory database creation

> Stupid question, but how can i create an in-memory database with > SQLite.NET provider? When i use Data Source=:memory: i get an exception > that the specified file isn't found. If you are using the ADOSQLiteDotNet provider from SourceForge, add "New=True" to your connection string.