Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  ADO issue with a stored procedure

Author  Topic  alebey Starting Member 17 Posts Posted - 2002-06-06 : 23:26:47 OK, this this has been haunting me for weeks now, and I desperately need some help. I have a stored procedure that I execute from a DLL using ADO 2.7. The stored procedure is on a sql server 2000. The DLL is executed by IIS 5 The thing is, most of the time everything runs smoothly. But every once in a while, it snags on something and two things happen: 1. IIS 5 hangs and doesn't process incoming requests (until restarted) 2. Communication with said SQL Server though ADO is killed until the database server is manually restarted. (everything runs fine without ADO) The chunk of code that snags it does a semi-complex logical condition on a simple view that joins two tables. The most annoying part is that it seems hang only occasionally, usually it runs days without hiccups. If anyone's ever encountered similar problem, please let me know. Thank you ahead for any help, or suggestions you might give.