sql and iis

[Jeff]

Our IIS and sql server(7.0) run on same machine. I am using ADO to query the SQL server to create a dropdown list of a field from a table . Sometimes the connections are blocked. It just hangs when we try to open a connection. It works fine if we use a html form and select fields to query a table .When the problem happens, it we stop and restart SQL server and IIS service, the problem is temperorily solved. It seems that SQL server is normal.From the sql query analyser, I can still run the same sql statement that I use in the record set. Just the connections between IIS and SQL server is blocked.

[ganesh]

Have you seen what is blocking the query? Use sp_who2 and find that


------------
Jeff at 11/16/00 12:09:58 PM


Our IIS and sql server(7.0) run on same machine. I am using ADO to query the SQL server to create a dropdown list of a field from a table . Sometimes the connections are blocked. It just hangs when we try to open a connection. It works fine if we use a html form and select fields to query a table .When the problem happens, it we stop and restart SQL server and IIS service, the problem is temperorily solved. It seems that SQL server is normal.From the sql query analyser, I can still run the same sql statement that I use in the record set. Just the connections between IIS and SQL server is blocked.

It seems that nobody is blocking the query.Blkby is null. The spid details is blank for that particular event. Is the connection mentioned in the Ado has not been established?


------------
ganesh at 11/16/00 12:49:09 PM

Have you seen what is blocking the query? Use sp_who2 and find that


------------
Jeff at 11/16/00 12:09:58 PM


Our IIS and sql server(7.0) run on same machine. I am using ADO to query the SQL server to create a dropdown list of a field from a table . Sometimes the connections are blocked. It just hangs when we try to open a connection. It works fine if we use a html form and select fields to query a table .When the problem happens, it we stop and restart SQL server and IIS service, the problem is temperorily solved. It seems that SQL server is normal.From the sql query analyser, I can still run the same sql statement that I use in the record set. Just the connections between IIS and SQL server is blocked.