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

[Jens Alfke]

> 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 enabled by a ‘pragma’ call.

> I just wanted to ask whether SQLite.NET  supports this 
> latter locking.

It will, unless it tries to do its own locking above SQLite. For instance if it 
uses a C# read-write lock that prevents other threads from making SQLite calls 
at all while one thread is in a transaction, because it “knows” that they’d 
just block.

But if it just stays out of the way and lets your code call the database, it 
should be OK. It wouldn’t be hard to write a little test app to see if this is 
the case.

—Jens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Sean McBride]

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 design the DB and 
use EF 6 and LINQ to access it.  



> On Jun 22, 2014, at 12:36 PM, Baruch Burstein  wrote:
> 
> This is not technically sqlite specific, rather .net in general, but it
> came up using sqlite.net, so I am asking here. If someone can point me to a
> general answer elsewhere, that would be great, too.
> I downloaded and "installed" (read: copied) the files to my project. I can
> create connections, commands, etc. but how do I get it to recognize my data
> structure? I only need to display a single table (with editing) in a
> datagrid, but it is very frustrating when I don't have any of the famed
> Visual Studio support for my types. Even if I create a structure manually
> that represents a single row, how do I load the data into it? How do I bind
> the grid to it? How do I search? I am not very familiar with C#, and the
> little I have done always involved connecting to a "datasource", which
> auto-populates everything, from creating a class to hold a row to Linq
> intellisense support (I suspect the two are related). How do I get this to
> work if I "Xcopy" installed, as recommended on the website?
> 
> Basically, can someone point me to a resource on using databases in C# only
> via manual code?
> 
> Baruch
> 
> -- 
> ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Kevin Keigwin]

Thank you for the information.  We will look forward to the next release.

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
Sent: Thursday, May 23, 2013 3:09 PM
To: 'General Discussion of SQLite Database'
Subject: 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:

https://system.data.sqlite.org/index.html/info/dcc277f29a

It will be present in the next release (1.0.86.0), due out shortly.
 
--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Joe Mistachkin]

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:

https://system.data.sqlite.org/index.html/info/dcc277f29a

It will be present in the next release (1.0.86.0), due out shortly.
 
--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[James K. Lowden]

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 datestring is a string, not a date.  You have the
option to use a CHECK constraint to restrict the column to valid date
strings.  

HTH.  

--jkl
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Simon Slavin]

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 SQLite is so
> forgiving when it comes to datatypes, it inserted the value even though it's
> not valid.  But when I tried to read it through SQLite.NET, it threw an
> exception.

Glad you sorted it.  Well done.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Kevin Keigwin]

>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 source code
and debugging the SQLiteDataAdapter.  I had created some test data through
the GUI tool and entered a non-ISO8601 date string.  Because SQLite is so
forgiving when it comes to datatypes, it inserted the value even though it's
not valid.  But when I tried to read it through SQLite.NET, it threw an
exception.

What I don't understand is why the database is so forgiving of dates being
saved, while the SQLiteDataAdapter isn't.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Simon Slavin]

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-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Kevin Keigwin]

>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 these columns is
text.  However, the SQLiteDataAdapter class tags the columns in the
DataTable as type DateTime when the FillSchema() method is called.  Even
when I alter this to make the columns of type String, a subsequent call to
Fill() generates the error.  Whatever is happening is inside the
SQLiteDataAdapter.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Simon Slavin]

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.

Download the sqlite3 shell tool and try some select commands for the your 
database in that.  Try something simple with a fixed tablename like

SELECT * FROM myTable

Does it work ?

Can you prove that your code is correctly executing any statement at all ?

> I've even tried modifying the code to change all DateTime columns in the
> DataTable to type String before the SELECT is executed, but it continues to
> complain about invalid DateTimes.

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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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
>download
>package section; however, perhaps there should be a more prominent notice on
>the top of the download page?

+1, since the origin of the error is not obvious and Google shows that
other users have struggle with this.

It might also be a good idea to add the following infos:

- what is the added-value is in the design-time components, which
requires downloading the Setup version

- when to choose the bundle vs. no-bundle version. The wiki seems a
bit abstract for non-.Net experts

- why should the static package intstead of the dynamic package; I
assume the dynamic version has the advantage of being indirectly
upgraded when the user upgrades the VC++ run-time

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Joe Mistachkin]

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, the error goes away.
> 
> Maybe the wiki should be edited accordingly.
>

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
download
package section; however, perhaps there should be a more prominent notice on
the top of the download page?

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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. (Exception from HRESULT: 0x8007007E)". Weird.

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, the error goes away.

Maybe the wiki should be edited accordingly.

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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 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. (Exception from HRESULT: 0x8007007E)". Weird.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[markus diersbock]

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
folder as the assembly.



On Thu, Apr 18, 2013 at 6:49 PM, Gilles Ganault  wrote:
> 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 new project.
>
> Why can't we just keep the two files in a central directory, and just
> add a reference through "Project > Add Reference"?
>
> Since the static-bundle version allows this, what is the added value
> of the other two (bundle and no-bundle, with dynamic linking to the
> VC++ runtime)?
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential information. If you have
received this e-mail in error, please contact the sender immediately
and delete the material from any computer. Any review, dissemination,
copying, printing or other use of this e-mail by persons or entities
other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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 new project.

Why can't we just keep the two files in a central directory, and just
add a reference through "Project > Add Reference"?

Since the static-bundle version allows this, what is the added value
of the other two (bundle and no-bundle, with dynamic linking to the
VC++ runtime)?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Marc L. Allen]

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 way to install precompiled binaries?

It has around 500 context switches per second.. so I'm thinking MosYield.

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of markus diersbock
Sent: Thursday, April 18, 2013 1:37 PM
To: General Discussion of SQLite Database
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 getting VB Express to find SQLite .Net:
>
> 1. I went to...
> http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
> ... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip
>
> 2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\
>
> 3. Launched VB Express 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to 
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to 
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data 
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item 
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES 
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The 
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can 
> find it?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential information. If you have received this 
e-mail in error, please contact the sender immediately and delete the material 
from any computer. Any review, dissemination, copying, printing or other use of 
this e-mail by persons or entities other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


This email and any attachments are only for use by the intended recipient(s) 
and may contain legally privileged, confidential, proprietary or otherwise 
private information. Any unauthorized use, reproduction, dissemination, 
distribution or other disclosure of the contents of this e-mail or its 
attachments is strictly prohibited. If you have received this email in error, 
please notify the sender immediately and delete the original.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


This email and any attachments are only for use by the intended recipient(s) 
and may contain legally privileged, confidential, proprietary or otherwise 
private information. Any unauthorized use, reproduction, dissemination, 
distribution or other disclosure of the contents of this e-mail or its 
attachments is strictly prohibited. If you have received this email in error, 
please notify the sender immediately and delete the original.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Marc L. Allen]

It has around 500 context switches per second.. so I'm thinking MosYield.

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of markus diersbock
Sent: Thursday, April 18, 2013 1:37 PM
To: General Discussion of SQLite Database
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 getting VB Express to find SQLite .Net:
>
> 1. I went to...
> http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
> ... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip
>
> 2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\
>
> 3. Launched VB Express 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to 
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to 
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data 
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item 
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES 
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The 
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can 
> find it?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential information. If you have received this 
e-mail in error, please contact the sender immediately and delete the material 
from any computer. Any review, dissemination, copying, printing or other use of 
this e-mail by persons or entities other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


This email and any attachments are only for use by the intended recipient(s) 
and may contain legally privileged, confidential, proprietary or otherwise 
private information. Any unauthorized use, reproduction, dissemination, 
distribution or other disclosure of the contents of this e-mail or its 
attachments is strictly prohibited. If you have received this email in error, 
please notify the sender immediately and delete the original.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[markus diersbock]

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...
> http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
> ... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip
>
> 2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\
>
> 3. Launched VB Express 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can
> find it?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 

Markus Diersbock
SwingNote
Marblehead, MA

C 781.929.0693
F 888.654.6068

This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential information. If you have
received this e-mail in error, please contact the sender immediately
and delete the material from any computer. Any review, dissemination,
copying, printing or other use of this e-mail by persons or entities
other than the addressee is prohibited.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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 password, there's no
Edit link anywhere.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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
(http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q8),
created .\Externals, and copied whole ZIP there:

===
\bin
\Externals
\My Project
\obj
Form1.resx
WindowsApplication1.vbproj.user
Form1.vb
Form1.Designer.vb
WindowsApplication1.vbproj
===

2. Added reference to "System.Data.SQLite.dll" in \Externals

3. Ran app: "Unable to load DLL 'SQLite.Interop.dll': The specified
module could not be found. (Exception from HRESULT: 0x8007007E)"

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

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 "SQLite.Interop.dll" file must
reside in the binary directory itself or in the architecture-specific
sub-directory therein.  The download page also covers this setup in
more detail."

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?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Kevin Benson]

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. I went to...
> http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
> ... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip
>
> 2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\
>
> 3. Launched VB Express 2010 to create new Windows Form project
>
> 4. Project > Add Reference: Navigated to
> "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to
> System.Data.SQLite.dll
>
> 5. Wrote SQLite test code:
>
> Dim SQLconnect As New SQLite.SQLiteConnection()
> Dim SQLcommand As SQLiteCommand
>
> 'Note: Non-admin app cannot write to c:\
> SQLconnect.ConnectionString = "Data
> Source=c:\users\fred\test.sqlite;"
> SQLconnect.Open()
>
> 'SQLcommand = SQLconnect.CreateCommand
>
> 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item
> (type)"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES
> ('something')"
> 'SQLcommand.ExecuteNonQuery()
>
> 'SQLcommand.Dispose()
> SQLconnect.Close()
>
> 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The
> specified module could not be found. (Exception from HRESULT:
> 0x8007007E)"
>
> What is the right way to install SQLite.Net so that applications can
> find it?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite.net build problems

[J Decker]

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 dll in the setup.Let me know if you are
> not clear.
>
> Regards,
> Netra Gona
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite.net download file

[Joe Mistachkin]

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

Yeah, that version of gacutil clearly belongs to the .NET Framework 3.5
(based on the version number displayed in your message).

You'll want to use the gacutil binary located in this directory:

"C:\Program Files\Microsoft SDKs\Windows\v7.1\Bin\NETFX 4.0 Tools"

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite.net download file

[majorthorburn]

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 Corporation.  All rights reserved.

Failure adding assembly to the cache:   This assembly is built by a
runtime newe
r than the currently loaded runtime and cannot be loaded.

Any hints?
Regards, Major.

>
> 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 .net.
>>
>
> Which help file mentions this?  Also, I'm not sure what is meant by
> "support for .net".  I can only assume this refers to the managed (or
> mixed-mode) System.Data.SQLite assembly.
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite.net download file

[majorthorburn]

>
> 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 downloads. I am running w7 x64 .net 4.0
>>
>> but have not managed to find the sqlite.net folder that the help file
>> mentions as support for .net.
>>
>
> Which help file mentions this?  Also, I'm not sure what is meant by
> "support for .net".  I can only assume this refers to the managed (or
> mixed-mode) System.Data.SQLite assembly.
>
help file was in system.data.sqlite and file name sqlite.net.chm

I have since discovered that the version of gacutil I have is from SDK 2
so am installing SDK 4 and will try the install using the bundle file
again.
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite.net download file

[Joe Mistachkin]

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

Which help file mentions this?  Also, I'm not sure what is meant by
"support for .net".  I can only assume this refers to the managed (or
mixed-mode) System.Data.SQLite assembly.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

RE: [sqlite] SQLite.Net

[Samuel R. Neff]

Funny, the first "bug" you pointed out is a question I asked which was
answered same day and was a report of an inconsistency with how
System.Data.SQLite tries to map strong typing on top of SQLite.  Certainly
wouldn't call it big issue and I worked around it in just as much time as it
took to post the question (the post was only to point out the
inconsistency).

Anyways, we're getting a bit off topic and from your earlier post I think we
both agree on recommending System.Data.SQLite which was the important part.

Best regards,

Sam

---
We're Hiring! Seeking a passionate developer to join our team building
products. Position 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 9:31 AM
To: sqlite-users@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/795.aspx
"Cannot retrieve data from a column; inconsistent results"

Another bug I reported was indeed replied quickly, but the forum didn't
notify me although specified. (I'll now do what the reply says...) So
the new forum software has other bugs, too.

http://sqlite.phxsoftware.com/forums/t/866.aspx
"Something's not cleaned up correctly"


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite.Net

[Yves Goergen]

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 results"

Another bug I reported was indeed replied quickly, but the forum didn't
notify me although specified. (I'll now do what the reply says...) So
the new forum software has other bugs, too.

http://sqlite.phxsoftware.com/forums/t/866.aspx
"Something's not cleaned up correctly"

-- 
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Samuel R. Neff]

Reports of two bugs would not have any bearing on my assertion of the
quality of SQLite.Data.NET, but can you be more specific?  Thread links.. 

Sam

---
We're Hiring! Seeking a passionate developer to join our team building
products. Position 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:
> 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 weeks. The one bug should have been fixed,
but isn't. But these errors are not critical and can be worked around in
the application code (probably decreasing the performance).

Still, this is my recommendation for using SQLite in .NET.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite.Net

[Yves Goergen]

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 weeks. The one bug should have been fixed,
but isn't. But these errors are not critical and can be worked around in
the application code (probably decreasing the performance).

Still, this is my recommendation for using SQLite in .NET.

-- 
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Samuel R. Neff]

Michael,

I haven't used the wrapper you mentioned so I can't help with the specific
problem in that wrapper.  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.  It's also an ADO.NET implementation making the code to use
the wrapper much easier to write for an experienced .NET developer and more
consistent with all other .NET database code.  I personally believe the
small amount of time it would take to convert would be worthwhile.

Perhaps changing the subject line to mention the specific wrapper
"phpguru.org's SQLite.NET wrapper" can attract the right attention.  You can
also e-mail the author of the wrapper since there is no mailing list for the
wrapper.  http://www.phpguru.org/static/freelance.html

HTH,

Sam


---
We’re Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
 
-Original Message-
From: Michael Martin [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 19, 2007 11: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'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 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
> 
> I am using this http://www.phpguru.org/static/SQLite.NET.html
> 
> I have the "attempted to read or write protected memory" 
> exception with this wrapper.
> 
> If I try to define my own wrapper with sqlite3.dll it crashes 
> on select statement.
> 
> -Message d'origine-
> De : Robert Simpson [mailto:[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 has issues as well.
> 
> Your best bet is to use the ADO.NET 2.0 provider at
> http://sqlite.phxsoftware.com
> 
> Robert


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Robert Simpson]

The wrapper on phpguru hasn't been updated in almost 3 years and isn't
actively maintained or supported.  I'm sure it worked fine against an older
version of the SQLite engine, but there've been quite a few changes to the
engine since then.

Robert


> -Original Message-
> From: Michael 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'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 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
> > 
> > I am using this http://www.phpguru.org/static/SQLite.NET.html
> > 
> > I have the "attempted to read or write protected memory" 
> > exception with this wrapper.
> > 
> > If I try to define my own wrapper with sqlite3.dll it crashes 
> > on select statement.
> > 
> > -Message d'origine-----
> > De : Robert Simpson [mailto:[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 has issues as well.
> > 
> > Your best bet is to use the ADO.NET 2.0 provider at
> > http://sqlite.phxsoftware.com
> > 
> > Robert
> >  
> > 
> > > -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 [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:[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 is my code :
> > > > 
> > > >  
> > > > 
> > > > SQLiteClient db= new SQLiteClient("test.db");
> > > > 
> > > > SQLiteResultSet results;
> > > > 
> > > > results = db.Execute("create table Table1(one 
> > > int primary
> > > > key, two varchar(10));");
> > > > 
> > > > results = db.Execute("insert into Table1
> > > > values(1,'hello');");
> > > > 
> > > > results = db.Execute("insert into Table1
> > > > values(2,'hello');");
> > > > 
> > > > results = db.Execute("select * from Table1");
> > > > 
> > > >  
> > > > 
> > > > The problem was on the select statement because I have a 
> > crash with
> > > > sqlite3.dll or a "attempted to read or write protected memory 
> > > > exception"
> > > > with sqlite.dll.
> > > > 
> > > >  
> > > > 
> > > > I don't understant why.
> > > > 
> > > >  
> > > > 
> > > > Could someone help me please
> > > > 
> > > >  
> > > > 
> > > > Thanks in advance
> > > > 
> > > >  
> > > > 
> > > >  
> > > > 
> > > >  
> > > > 
> > > >

RE: [sqlite] SQLite.Net

[Michael Martin]

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 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
> 
> I am using this http://www.phpguru.org/static/SQLite.NET.html
> 
> I have the "attempted to read or write protected memory" 
> exception with this wrapper.
> 
> If I try to define my own wrapper with sqlite3.dll it crashes 
> on select statement.
> 
> -Message d'origine-
> De : Robert Simpson [mailto:[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 has issues as well.
> 
> Your best bet is to use the ADO.NET 2.0 provider at
> http://sqlite.phxsoftware.com
> 
> Robert
>  
> 
> > -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 [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:[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 is my code :
> > > 
> > >  
> > > 
> > > SQLiteClient db= new SQLiteClient("test.db");
> > > 
> > > SQLiteResultSet results;
> > > 
> > > results = db.Execute("create table Table1(one 
> > int primary
> > > key, two varchar(10));");
> > > 
> > > results = db.Execute("insert into Table1
> > > values(1,'hello');");
> > > 
> > > results = db.Execute("insert into Table1
> > > values(2,'hello');");
> > > 
> > > results = db.Execute("select * from Table1");
> > > 
> > >  
> > > 
> > > The problem was on the select statement because I have a 
> crash with
> > > sqlite3.dll or a "attempted to read or write protected memory 
> > > exception"
> > > with sqlite.dll.
> > > 
> > >  
> > > 
> > > I don't understant why.
> > > 
> > >  
> > > 
> > > Could someone help me please
> > > 
> > >  
> > > 
> > > Thanks in advance
> > > 
> > >  
> > > 
> > >  
> > > 
> > >  
> > > 
> > > 
> > 
> > 
> > 
> > --
> > ---
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > --
> > ---
> > 
> > 
> > --
> > ---
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > --
> > ---
> > 
> 
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Robert Simpson]

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
> 
> I am using this http://www.phpguru.org/static/SQLite.NET.html
> 
> I have the "attempted to read or write protected memory" 
> exception with this wrapper.
> 
> If I try to define my own wrapper with sqlite3.dll it crashes 
> on select statement.
> 
> -Message d'origine-
> De : Robert Simpson [mailto:[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 has issues as well.
> 
> Your best bet is to use the ADO.NET 2.0 provider at
> http://sqlite.phxsoftware.com
> 
> Robert
>  
> 
> > -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 [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:[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 is my code :
> > > 
> > >  
> > > 
> > > SQLiteClient db= new SQLiteClient("test.db");
> > > 
> > > SQLiteResultSet results;
> > > 
> > > results = db.Execute("create table Table1(one 
> > int primary
> > > key, two varchar(10));");
> > > 
> > > results = db.Execute("insert into Table1
> > > values(1,'hello');");
> > > 
> > > results = db.Execute("insert into Table1
> > > values(2,'hello');");
> > > 
> > > results = db.Execute("select * from Table1");
> > > 
> > >  
> > > 
> > > The problem was on the select statement because I have a 
> crash with
> > > sqlite3.dll or a "attempted to read or write protected memory 
> > > exception"
> > > with sqlite.dll.
> > > 
> > >  
> > > 
> > > I don't understant why.
> > > 
> > >  
> > > 
> > > Could someone help me please
> > > 
> > >  
> > > 
> > > Thanks in advance
> > > 
> > >  
> > > 
> > >  
> > > 
> > >  
> > > 
> > > 
> > 
> > 
> > 
> > --
> > ---
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > --
> > ---
> > 
> > 
> > --
> > ---
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > --
> > ---
> > 
> 
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Michael Martin]

I am using this http://www.phpguru.org/static/SQLite.NET.html

I have the "attempted to read or write protected memory" exception with this 
wrapper.

If I try to define my own wrapper with sqlite3.dll it crashes on select 
statement.

-Message d'origine-
De : Robert Simpson [mailto:[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 has issues as well.

Your best bet is to use the ADO.NET 2.0 provider at
http://sqlite.phxsoftware.com

Robert
 

> -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 [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:[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 is my code :
> > 
> >  
> > 
> > SQLiteClient db= new SQLiteClient("test.db");
> > 
> > SQLiteResultSet results;
> > 
> > results = db.Execute("create table Table1(one 
> int primary
> > key, two varchar(10));");
> > 
> > results = db.Execute("insert into Table1
> > values(1,'hello');");
> > 
> > results = db.Execute("insert into Table1
> > values(2,'hello');");
> > 
> > results = db.Execute("select * from Table1");
> > 
> >  
> > 
> > The problem was on the select statement because I have a crash with
> > sqlite3.dll or a "attempted to read or write protected memory 
> > exception"
> > with sqlite.dll.
> > 
> >  
> > 
> > I don't understant why.
> > 
> >  
> > 
> > Could someone help me please
> > 
> >  
> > 
> > Thanks in advance
> > 
> >  
> > 
> >  
> > 
> >  
> > 
> > 
> 
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Robert Simpson]

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 has issues as well.

Your best bet is to use the ADO.NET 2.0 provider at
http://sqlite.phxsoftware.com

Robert
 

> -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 [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:[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 is my code :
> > 
> >  
> > 
> > SQLiteClient db= new SQLiteClient("test.db");
> > 
> > SQLiteResultSet results;
> > 
> > results = db.Execute("create table Table1(one 
> int primary
> > key, two varchar(10));");
> > 
> > results = db.Execute("insert into Table1
> > values(1,'hello');");
> > 
> > results = db.Execute("insert into Table1
> > values(2,'hello');");
> > 
> > results = db.Execute("select * from Table1");
> > 
> >  
> > 
> > The problem was on the select statement because I have a crash with
> > sqlite3.dll or a "attempted to read or write protected memory 
> > exception"
> > with sqlite.dll.
> > 
> >  
> > 
> > I don't understant why.
> > 
> >  
> > 
> > Could someone help me please
> > 
> >  
> > 
> > Thanks in advance
> > 
> >  
> > 
> >  
> > 
> >  
> > 
> > 
> 
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 
> 
> --
> ---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
> ---
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Michael Martin]

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:[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 is my code :
> 
>  
> 
> SQLiteClient db= new SQLiteClient("test.db");
> 
> SQLiteResultSet results;
> 
> results = db.Execute("create table Table1(one int primary
> key, two varchar(10));");
> 
> results = db.Execute("insert into Table1
> values(1,'hello');");
> 
> results = db.Execute("insert into Table1
> values(2,'hello');");
> 
> results = db.Execute("select * from Table1");
> 
>  
> 
> The problem was on the select statement because I have a crash with
> sqlite3.dll or a "attempted to read or write protected memory 
> exception"
> with sqlite.dll.
> 
>  
> 
> I don't understant why.
> 
>  
> 
> Could someone help me please
> 
>  
> 
> Thanks in advance
> 
>  
> 
>  
> 
>  
> 
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] SQLite.Net

[Robert Simpson]

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 is my code :
> 
>  
> 
> SQLiteClient db= new SQLiteClient("test.db");
> 
> SQLiteResultSet results;
> 
> results = db.Execute("create table Table1(one int primary
> key, two varchar(10));");
> 
> results = db.Execute("insert into Table1
> values(1,'hello');");
> 
> results = db.Execute("insert into Table1
> values(2,'hello');");
> 
> results = db.Execute("select * from Table1");
> 
>  
> 
> The problem was on the select statement because I have a crash with
> sqlite3.dll or a "attempted to read or write protected memory 
> exception"
> with sqlite.dll.
> 
>  
> 
> I don't understant why.
> 
>  
> 
> Could someone help me please
> 
>  
> 
> Thanks in advance
> 
>  
> 
>  
> 
>  
> 
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Peter Berkenbosch]

-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 provider from SourceForge, add 
>>"New=True" 
>>to your connection string.
> 
> 
> To clarify, my connection strings for in-memory databases look like this:
> 
> "Data Source=:memory:;Version=3;New=True"
> 
> 

mmm. looks like it only fails with version=2; thx for the input.

- --
+---+--+
: Peter Berkenbosch :  :
:   : t: +31 (0) 64 84 61653   :
: PeRo ICT Solutions: f: +31 (0) 84 22 09880   :
: Koemaad 26: m: [EMAIL PROTECTED] :
: 8431 TM Oosterwolde   : w: www.pero-ict.nl   :
+---+--+
: OpenPGP 0x0F655F0D (random.sks.keyserver.penguin.de) :
+--+





-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)

iD8DBQFCw+oO9bwznA9lXw0RAmjnAJ9PuIJuAPT89EfIX2j0h82QIYEHuwCglCaa
kPj1DUjfGPJr9+mfiGAvyu8=
=8mhF
-END PGP SIGNATURE-

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

[Peter Berkenbosch]

-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 ?
> 
> Thanks in advance.
> 
> Regards
> Peter


Just found out that there's a bug report on
http://sourceforge.net/tracker/index.php?func=detail=1187987_id=94056=606537


- --
+---+--+
: Peter Berkenbosch :  :
:   : t: +31 (0) 64 84 61653   :
: PeRo ICT Solutions: f: +31 (0) 84 22 09880   :
: Koemaad 26: m: [EMAIL PROTECTED] :
: 8431 TM Oosterwolde   : w: www.pero-ict.nl   :
+---+--+
: OpenPGP 0x0F655F0D (random.sks.keyserver.penguin.de) :
+--+





-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)

iD8DBQFCw+Sb9bwznA9lXw0RAhJ2AJ9XqAjJqVq4F2xr6Bc99Vkzuv6wGQCfe9Co
L5mNRHr4bZTa4yUUZtwQXnw=
=Alav
-END PGP SIGNATURE-

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

[Brass Tilde]

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

To clarify, my connection strings for in-memory databases look like this:

"Data Source=:memory:;Version=3;New=True"

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

[Brass Tilde]

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