Hy Everyone!
I’m a software developer and, in my application, I have a problem with the NHibernate’ Connections.
In particular I need to detach/attach my database (with another DB with the same name but different data) while my application is running.
I can do it; but at the first query with Hibernate I’ve this error message: “There’s an error in the transport level when sending the request to the server - Provider shared memory, error: 0 – No process in the other side of the pipe.”
Can everyone help me?
Thank’s

I have the same exact problem.

I have a database that need to be taked offline, and after teked online again.
The application need to be always running, but after the database was restarted at the first query I get the error "No process in the other side of the pipe".

Hey! Yeah I find the solution.

As described in this post:

http://www.devnewsgroups.net/group/micr ... 54394.aspx

The problem was the System.Data.SqlClient.SqlConnection class that make a cache of the DB conection. since database is restarted,
connection is not valid anymore.

To solve this problem set pooling=false in the connection string used to access the database.

I hope that this could help.

Regards

OK! Thanks a lot for your help.
I've solve my problem with "pooling=false".
Great