- Joined
- Sep 22, 2006
- Messages
- 1
- Reaction score
- 0
Sorry in advance for the dumb question but I can't find an answer in the documentation. I'm using a .Net ADO connection to access an SQL Server 2005 DB from ASP.Net running on IIS6 / Windows2003.
Connection pooling is on by default. I use just default settings for the connection string nothing special the string is given below:
Data Source=192.168.1.7;Initial Catalog=XXX;UID=XX;PWD=XXX
If my database reboots or is stopped the .Net looses its connections to the database - fair enough. When it comes back up I can't seem to get .Net to reconnect automatically to the database for its pooled connections that it lost.
Is there a setting somewhere. Will lost connections be deleted or reconnected from the pool automatically? How long does it take for them to be cleared?
Any help much appreciated.
Regards
Tim
Connection pooling is on by default. I use just default settings for the connection string nothing special the string is given below:
Data Source=192.168.1.7;Initial Catalog=XXX;UID=XX;PWD=XXX
If my database reboots or is stopped the .Net looses its connections to the database - fair enough. When it comes back up I can't seem to get .Net to reconnect automatically to the database for its pooled connections that it lost.
Is there a setting somewhere. Will lost connections be deleted or reconnected from the pool automatically? How long does it take for them to be cleared?
Any help much appreciated.
Regards
Tim