Can not register OraOLEDB.dll COM object

[Guest]

We're running XP Pro with SP2. Installation of Oracle Client also
installs/registers two COM objects used for connecting to Oracle remotely
using OLE DB. These are oci.dll and OraOLEDB.dll. These are failing to
register during install. Creation of a *.udl file shows their Provider
missing. Manual attempts to register these - using 'regsvr32.exe' also fail
with an 0x0000007e error - saying file not found. The files ARE there
(viewed with Windows Explorer), the path variable includes their directory
(c:\oracle\ora92\bin), and security has been checked on both the folders and
users (appear OK). But consistently returns "not found". We're not having
any problem with XP Pro running SP1 (OraOLEDB works fine) - so think some
security settings have been "beefed up" in SP2 that prevent the registration
of needed Oracle COM objects. I checked and the firewall is "off". Any help
or pointers would be appreciated.

 

[igormonteiro]

Hello Buddie, how you doing?

I just solved my problem.

Verifying which DLL were missing through OraOleDB.dll, using the tool "Dependency Walker", I downloaded and put them into the respective directories. I'm going to show you.

Must be aware you needn't overwrite any DLL.

In my scenario, having Oracle Client 8.1.7.0, the missing dll are following below:

%ORACLE_HOME%\bin :

- OraOLEDButl.dll

- OraOLEDBrst.dll

- OraOLEDBgmr.dll

- OraOLEDBpus.dll

- OraOLEDBus.dll

%WINDIR%\system32\ :

- DWMAPI.dll

- WINHTTP.dll

- GDIPLUS.dll

Just make sure the OraOleDB.dll registering is complain to the tree DLL dependencies.

I hope it can help you.

Igor Monteiro.