General discussion

Locked

IIS 4.0 Holding SQL 7 Connections open

By rsutton ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

IIS 4.0 Holding SQL 7 Connections open

by roc180 In reply to IIS 4.0 Holding SQL 7 Con ...

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

Collapse -

IIS 4.0 Holding SQL 7 Connections open

by rsutton In reply to IIS 4.0 Holding SQL 7 Con ...

Poster rated this answer

Collapse -

IIS 4.0 Holding SQL 7 Connections open

by rsutton In reply to IIS 4.0 Holding SQL 7 Con ...

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums