I have a ASP website installed on Windows 2003 using Microsoft Access. Now it had been working until yesterday when a windows update suddenly resulted in this error on all DB connected ASP pages:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/includes/CommonCode.inc, line 12
After pouring over forums, I have come to learn that the MDAC is corrupted. I had 2.8 previously installed. After trying to re-nstall MDAC with no success, I tried installing Windows 2003 Service Pack 2. I believe this is supposed to install MDAC 2.8 service pack 2. This also gets the latest Jet 4.0 engine. On running Component Checker, the version comes up as UNKNOWN, but I am guessing that this is because the service pack was released recently and is therefore unrecognized.
However, after all this, I still get the same error and for the life of me cannot figure out what to do. Could anyone please help!!
P.S. My connection strings(which were working) are of the form:
Set oConn = Server.CreateObject("ADODB.Connection")
= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&sDBPath&";Persist Security Info=False"
It sounds that all the usual advice about checking MDAC, reinstall etc is already tried, then there's the extreme versions - I think you're ready for what this user experienced (from one of Microsoft public NGs) http://groups.google.com/group/micro...cf7c9fd54454e9