Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

2012-08-17 Thread Wayne Bradney 
Ah, there you go. I'd assumed the latest nuget package would have this already. 
Thanks.
 > From: kevin.m.ben...@gmail.com
> Date: Fri, 17 Aug 2012 22:54:58 -0400
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How to connect to an in-memory, shared cache db via 
> SQLiteConnection
> 
> On Fri, Aug 17, 2012 at 8:51 PM, Wayne Bradney <wayne_brad...@yahoo.com>wrote:
> 
> >
> >
> >
> > I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the
> > following connection string: FullUri='file::memory:?cache=shared; when I
> > Open() the SQLiteConnection, I get: Invalid ConnectionString format for
> > parameter "FullUri" What am I doing wrong?
> > ___
> >
> 
> http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki
> 
> 
> *Version History*
> 
> *1.0.82.0 - September XX, 2012 (release scheduled)*
> 
> Add support for URI file names <http://www.sqlite.org/uri.html> via the new
> FullUri connection string property.
> 
> 
> > --
> >--
> >   --
> >  --Ô¿Ô--
> > K e V i N
> >
> ___
> 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] How to connect to an in-memory, shared cache db via SQLiteConnection

2012-08-17 Thread Kevin Benson 
On Fri, Aug 17, 2012 at 8:51 PM, Wayne Bradney wrote:

>
>
>
> I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the
> following connection string: FullUri='file::memory:?cache=shared; when I
> Open() the SQLiteConnection, I get: Invalid ConnectionString format for
> parameter "FullUri" What am I doing wrong?
> ___
>

http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki


*Version History*

*1.0.82.0 - September XX, 2012 (release scheduled)*

Add support for URI file names  via the new
FullUri connection string property.


> --
>--
>   --
>  --Ô¿Ô--
> K e V i N
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

2012-08-17 Thread Udon Shaun 
the ":memory:" is the old format and not a uri format

It should be something like:


file:mymemorydb.db?mode=memory=shared




 From: Wayne Bradney <wayne_brad...@yahoo.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org> 
Sent: Saturday, August 18, 2012 2:51 AM
Subject: Re: [sqlite] How to connect to an in-memory, shared cache db via 
SQLiteConnection
 
Sorry, I'd already removed the quote - still doesn't work. Here's what I've 
tried:             const string connectionString = @"FullUri=file::memory:"; 
gives: Data Source cannot be empty.  Use :memory: to open an in-memory 
database             const string connectionString = 
@"FullUri=file::memory:?cache=shared"; gives: Invalid ConnectionString format 
for parameter "FullUri"             const string connectionString = @"Data 
Source=:memory:"; works, but doesn't give me the shared cache I need.           
  const string connectionString = @"Data Source=:memory:?cache=shared"; gives: 
Invalid ConnectionString format for parameter "Data Source" I just can't seem 
to get a shared cache, in-memory db no matter what I try!
> From: slav...@bigfraud.org
> Date: Sat, 18 Aug 2012 02:15:13 +0100
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How to connect to an in-memory,    shared cache db via 
> SQLiteConnection
> 
> 
> On 18 Aug 2012, at 1:51am, Wayne Bradney <wayne_brad...@yahoo.com> wrote:
> 
> > I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the following 
> > connection string: FullUri='file::memory:?cache=shared;  when I Open() the 
> > SQLiteConnection, I get: Invalid ConnectionString format for parameter 
> > "FullUri" What am I doing wrong?    
> 
> I think it's the quote.  Try using
> 
> FullUri=file::memory:?cache=shared;
> 
> instead.  If that doesn't work, try just
> 
> FullUri=file::memory:
> 
> for debugging purposes.
> 
> Simon.
> ___
> 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
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

2012-08-17 Thread Wayne Bradney 
Sorry, I'd already removed the quote - still doesn't work. Here's what I've 
tried: const string connectionString = @"FullUri=file::memory:"; 
gives: Data Source cannot be empty.  Use :memory: to open an in-memory database 
const string connectionString = 
@"FullUri=file::memory:?cache=shared"; gives: Invalid ConnectionString format 
for parameter "FullUri" const string connectionString = @"Data 
Source=:memory:"; works, but doesn't give me the shared cache I need.   
  const string connectionString = @"Data Source=:memory:?cache=shared"; gives: 
Invalid ConnectionString format for parameter "Data Source" I just can't seem 
to get a shared cache, in-memory db no matter what I try!
 > From: slav...@bigfraud.org
> Date: Sat, 18 Aug 2012 02:15:13 +0100
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How to connect to an in-memory, shared cache db via 
> SQLiteConnection
> 
> 
> On 18 Aug 2012, at 1:51am, Wayne Bradney <wayne_brad...@yahoo.com> wrote:
> 
> > I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the following 
> > connection string: FullUri='file::memory:?cache=shared;  when I Open() the 
> > SQLiteConnection, I get: Invalid ConnectionString format for parameter 
> > "FullUri" What am I doing wrong?
> 
> I think it's the quote.  Try using
> 
> FullUri=file::memory:?cache=shared;
> 
> instead.  If that doesn't work, try just
> 
> FullUri=file::memory:
> 
> for debugging purposes.
> 
> Simon.
> ___
> 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] How to connect to an in-memory, shared cache db via SQLiteConnection

2012-08-17 Thread Simon Slavin 

On 18 Aug 2012, at 1:51am, Wayne Bradney  wrote:

> I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the following 
> connection string: FullUri='file::memory:?cache=shared;  when I Open() the 
> SQLiteConnection, I get: Invalid ConnectionString format for parameter 
> "FullUri" What am I doing wrong?

I think it's the quote.  Try using

FullUri=file::memory:?cache=shared;

instead.  If that doesn't work, try just

FullUri=file::memory:

for debugging purposes.

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