Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP Jet 4 Connection Failure w/ MS Access

Status
Not open for further replies.

Tarwn

Programmer
Mar 20, 2001
5,787
US
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top