Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help, Code Locks up | Excel Discussion (Misc queries) | |||
Need to look at vba code in a file but excel locks up each time I | Excel Programming | |||
Execute code on server | Excel Programming | |||
Handling Server Paths in code | Excel Programming |