the ":memory:" is the old format and not a uri format It should be something like:
file:mymemorydb.db?mode=memory&cache=shared ________________________________ From: Wayne Bradney <[email protected]> To: General Discussion of SQLite Database <[email protected]> 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: [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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
