I have a curious problem that I can't fix.
Monday morning I could connect fine from asp pages to access databases. I have been developing small web sites that do that for well over a year. My production machine is a dell laptop running win2k server, SP2. I have had no issues in the past with my database connecions. The only program installed on monday between the working and non-working states was zone alarm, it does not start automatically at boot, so i doubt that is an issue. I have also check the event viewer in admin tools, the error and warnings are listed at the bottom of the post.
The Problem: Any webpage that tries to do a query then checks for an eof always gets an eof (even a select * from table). Any page that relies directly on information from a database to build the page hangs as if it were in an endless do while loop(dllhost gets 99% processor until page times out). I checked with visual studio, vb can still use the same exact connection string to connect using ADODB. I am using ADODB for the web pages. This is not one db, every website running on my machine that connects to an access db has failed. Any sites running off of MS SQLServer work fine.
I tried to patch it. I applied Office SR1a, SR patches, patched Jet 4 drivers up to SP6. The only person I can find that has had this problem before resorted to uninstalling office completely, then reinstalling, and then repeating 3 or 4 times until it magically started working again.
Any assistance would be helpful.
Log Error and Warnings:
Error:
Source: Server
Message: The value named IRPStackSize in the server's Registry key LanmanServer\Parameters was invalid. The value was ignored, and processing continued.
Warning:
Source: BROWSER
Message: The value for the parameter DirectHostBinding to the browser service was illegal.
Error:
Source: Service Control Manager
Message:The Messenger service terminated with service-specific error 2119.
Error: There were approx 10 of these, all similar CE related
Source: WinMgmt
Message: WMI ADAP was unable to retrieve data from the PerfLib subkey: SYSTEM\CurrentControlSet\Services\CEUDPPerf\Performance\Library, error code: 0x80041009
Monday morning I could connect fine from asp pages to access databases. I have been developing small web sites that do that for well over a year. My production machine is a dell laptop running win2k server, SP2. I have had no issues in the past with my database connecions. The only program installed on monday between the working and non-working states was zone alarm, it does not start automatically at boot, so i doubt that is an issue. I have also check the event viewer in admin tools, the error and warnings are listed at the bottom of the post.
The Problem: Any webpage that tries to do a query then checks for an eof always gets an eof (even a select * from table). Any page that relies directly on information from a database to build the page hangs as if it were in an endless do while loop(dllhost gets 99% processor until page times out). I checked with visual studio, vb can still use the same exact connection string to connect using ADODB. I am using ADODB for the web pages. This is not one db, every website running on my machine that connects to an access db has failed. Any sites running off of MS SQLServer work fine.
I tried to patch it. I applied Office SR1a, SR patches, patched Jet 4 drivers up to SP6. The only person I can find that has had this problem before resorted to uninstalling office completely, then reinstalling, and then repeating 3 or 4 times until it magically started working again.
Any assistance would be helpful.
Log Error and Warnings:
Error:
Source: Server
Message: The value named IRPStackSize in the server's Registry key LanmanServer\Parameters was invalid. The value was ignored, and processing continued.
Warning:
Source: BROWSER
Message: The value for the parameter DirectHostBinding to the browser service was illegal.
Error:
Source: Service Control Manager
Message:The Messenger service terminated with service-specific error 2119.
Error: There were approx 10 of these, all similar CE related
Source: WinMgmt
Message: WMI ADAP was unable to retrieve data from the PerfLib subkey: SYSTEM\CurrentControlSet\Services\CEUDPPerf\Performance\Library, error code: 0x80041009