![]() |
Exel Code Locks up my Web Server
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??? |
All times are GMT +1. The time now is 06:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com