Discussion Locked

IIS 4.0 Holding SQL 7 Connections open

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a IIS 4 web server that opens connections to my SQL 7 server. My problem is that the connections stay open even though the session or user is no longer active. I know there is some pooling but I am seeing connections only being added and never being dropped.

3 replies

by roc180

I imagine you are using ADO from your web pages to retrive data from SQL Server 7. If so make sure that when a user is done that all their session objects are destroyed. In VB script setting an object=nothing (Set ADOConnection = Nothing) will destroy it and release the connection.

Neal Martinelli

This discussion is closed to new replies.