ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Exel Code Locks up my Web Server (https://www.excelbanter.com/excel-programming/366999-exel-code-locks-up-my-web-server.html)

Randy VanDeMaat MCAD

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