Re: [sqlite] Multiple connections to in-memory database

2012-07-05 Thread Jay A. Kreibich
On Thu, Jul 05, 2012 at 09:03:54AM -0400, Pavel Ivanov scratched on the wall: > So this feature shouldn't work for you. From my first message: > > > But this possibility was > > introduced in SQLite 3.7.13. So your asp.net provider should be > > compiled with the latest version of SQLite, otherwis

Re: [sqlite] Multiple connections to in-memory database

2012-07-05 Thread T Ü
Thank you so much Pavel. I will try with the new version. From: Pavel Ivanov To: T Ü Cc: General Discussion of SQLite Database Sent: Thursday, July 5, 2012 4:03 PM Subject: Re: [sqlite] Multiple connections to in-memory database So this feature shouldn&#

Re: [sqlite] Multiple connections to in-memory database

2012-07-05 Thread Pavel Ivanov
wrote: > It returns 3.6.23.1 > > > From: Pavel Ivanov > To: T Ü > Cc: General Discussion of SQLite Database > Sent: Thursday, July 5, 2012 3:40 PM > > Subject: Re: [sqlite] Multiple connections to in-memory database > > On Thu, Jul

Re: [sqlite] Multiple connections to in-memory database

2012-07-05 Thread T Ü
It returns 3.6.23.1 From: Pavel Ivanov To: T Ü Cc: General Discussion of SQLite Database Sent: Thursday, July 5, 2012 3:40 PM Subject: Re: [sqlite] Multiple connections to in-memory database On Thu, Jul 5, 2012 at 8:37 AM, T Ü wrote: > By trying I fo

Re: [sqlite] Multiple connections to in-memory database

2012-07-05 Thread Pavel Ivanov
On Thu, Jul 5, 2012 at 8:37 AM, T Ü wrote: > By trying I found out that SQLiteConnection("Data > Source=:memory:;cache=shared"); worked. > In a single aspx.page at cs code, first I open an in-memory database > connection > SQLiteConnection conn = new SQLiteConnection ( "Data > Source=:memo

Re: [sqlite] Multiple connections to in-memory database

2012-07-05 Thread T Ü
___ From: Pavel Ivanov To: T Ü ; General Discussion of SQLite Database Sent: Thursday, July 5, 2012 3:21 PM Subject: Re: [sqlite] Multiple connections to in-memory database On Thu, Jul 5, 2012 at 7:46 AM, T Ü wrote: > I have an asp.net application. > I open a sqlite in-memory connec

Re: [sqlite] Multiple connections to in-memory database

2012-07-05 Thread Pavel Ivanov
On Thu, Jul 5, 2012 at 7:46 AM, T Ü wrote: > I have an asp.net application. > I open a sqlite in-memory connection with SQLiteConnection conn = new > SQLiteConnection ( "Data Source=:memory:" ); command. > I read that by using cache=shared parameter, I can make that in-memory > database reachabl

[sqlite] Multiple connections to in-memory database

2012-07-05 Thread T Ü
I have an asp.net application. I open a sqlite in-memory connection with SQLiteConnection conn = new SQLiteConnection ( "Data Source=:memory:" ); command. I read that by using cache=shared parameter, I can make that in-memory database reachable from other connections. 1.What is the way of applyi