April 27, 2005 at 5:50 am
Hi all
We have set up some web services that our externally hosted website uses to access our backend database (mssql2000), but some of the calls do not seem to be connection pooling properly, each time a certain method is called it seems to not release the connection back to the pool...its a simple stored procedure call that uses an output parameter, I've set nocount on in the sp and closed the ado.net connection in a finally block...we also use a common connection string for all methods so there is only one connection pool created.
anyone had similar problems or know of a solution?
thanks
Neil
May 3, 2005 at 10:17 am
after a bit of head scratching I installed the app to a different virtual directory on the same server and it worked fine...so I deleted the original app and redeployed it...and its all working fine now
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply