I have code behind a workbook that connects to an SQL/Web server, running on
Windows Server 2003, to pull information from the database and display it in
Excel. I am using an OLEDB connection and a standard Transact-SQL statement
with an isolation level of Read Uncommitted. Every so often, it locks up my
server and I have to do an IIS RESET to clear it up. This is very
inconsistant and I can not pin point what is causing this to happen. I
remember seeing a whitepaper from Microsoft about COM + objects sometimes
Locking up the Application Pool on a Windows 2003 server, but I can't find it
again. Anyone have any ideas???