Tuesday, March 6, 2012

ADODB.Connection error 800a0e7a

I am getting the following error, when I try to run my ASP Web pages on an NT4 server has anyone got any Ideas ?

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

I have installed every service pack and rebooted even reregistering .dlls

Anyone got any Ideas ?If your problem is like mine, you are getting this error because your MDAC got hosed.
I was un-installing something seemingly harmless and before I knew it I saw a flurry of mdac dlls being deleted.
After that, SQLServer7's Enterprise Manager and other VB6 database apps started failing with this error.
I re-installed the MDAC (26) and it (thankfully) fixed the problem.
Hope this helps.|||I agree - reinstall your mdac. You can try to reregister the individual dll that is causing the problem - but that may only be a partial fix.

No comments:

Post a Comment