Maximum Connection Pool Error Query

[iaresean]

Hi All;

I have been getting the maximum connection pool error on an ASP.NET 1.1 site that I am responsible for maintaining. It doesn't happen very often so I am assuming there are some connections being used that aren't being closed properly or garbage collected.

My query is this:
Is the maximum connection pool error an error that happens per database, or do all the different databases on the database server share the connection pool?

I am trying to establish whether in fact the error is being caused by another site (which is apparently badly coded) on our web server.

Thanks for any and all insight and advice.

Sean.

 

[mrdenny]

SQL doesn't have a connection pool. Connection Pools are application specific. If memory serves you should have a connection pool for each database that you application connects to.

They aren't global accross the web server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sweth]

Check that you are using same connection string and not changing it in your application, ie

 

[iaresean]

Thanks Mr Denny - so the problem does lie in my application.

Sweth - ie?

Thank you for responses once again!

Sean.

 

[mrdenny]

yep.

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sweth]

Sorry hit the send button before completing the message, As Denny said your connection will get pooled if you use same connection string. May be an encrypted connection string in web.config file will be handy for this.

Sweth