> 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
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
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
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:
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
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
>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
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
>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
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.
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
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,
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.
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
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
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
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
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
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...
>
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
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?
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
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
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.
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
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
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
>
> 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
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
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
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
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
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
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
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
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
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
>
>
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
> -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
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:
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
-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
-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 ?
> > 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
> 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.
45 matches
Mail list logo