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: [email protected]
> Date: Sat, 18 Aug 2012 02:15:13 +0100
> To: [email protected]
> Subject: Re: [sqlite] How to connect to an in-memory, shared cache db via
> SQLiteConnection
>
>
> On 18 Aug 2012, at 1:51am, Wayne Bradney <[email protected]> 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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
