XP SP2 OraOLEDB Provider cannot be found.
437701Feb 3 2005 — edited Apr 7 2010Running XP with SP2 and Oracle client 9.2 both installed fresh yesterday - both oci.dll and OraOLEDB.dll exist - Oracle installer shows OraOLEDB installed - yet I throw an error 0x800A0E7A "Provider cannot be found" from a vba macro when doing an ADO connection using the OraOLEDB provider. Tried most suggestions I found on the web as follows:
1) created *.udl file to list providers but Oracle OLEDB driver not shown.
2) tried running "regsvr32.exe" on OraOLEDB.dll and fails returning error stating that that oci.dll and OraOLEDB.dll could not be found (even though I see them using Windows Explorer).
3) checked "authorized users" security and security on oracle folders and path variable -- all OK.
4) tried logging onto another users machine (running XP with SP1) to eliminate my userid security as being a suspect .. vbscript connection works fine. It's not my userid security settings.
Just confounding. I kind of suspect that Service Pack 2 has tightened security to point to where OraOLEDB fails to be registered during the Oracle 9.2 Client install or even manually when running "regsvr32.exe. Anyone that has similar problem and/or solutions please speak up. Any information that helps solve this would be greatly appreciated.
Tnanks ahead of time for your help.