Oracle Database Discussions

Please help! I have been trying all of the fixes on the internet and nothing seems to work. I am trying to use the Oracle OLE DB Provider to run a 32 bit application on a 64 bit server - tried on a 2008 R2 and a 2003 SP2, both fail. I have tried with Oracle 11g 11.1.0.6.0 client and the 10.2.0.4.0 client - both fail.

It keeps installing the bin and inventory directories into the Program Files (x86) folder and I am assuming it is trying to run the 64 bit dll's instead of the 32 bit Oracle OLE DB provider DLL's. I have made a new installation and had it install into C:\ProgramFilesx86 but it still installs the bin and inventory files into C:\Program Files (x86). I have tried moving the contents and editing the registry, all I can find is that the inst_loc is pointing to C:\Program Files (x86)\Oracle\Inventory so I change it to the file I created and restart the computer, still get an error when trying to test using a udl file.

Error shows: "Provider is no longer available. Ensure that the provider is installed properly."

I have also tried unregistering the OLE DB dll's located inside C:\Program Files\Common Files\System\Ole DB for oledb32.dll and oledb32r.dll. It only lets me unregister the oledb32.dll. For oledb32r.dll it says the entry point for dllregisterserver was not found. I then register the oledb32.dll file inside of C:\program files (x86)\common files\system\ole db and then restart the server. Still get the UDL error and when i try to connect the application it just say DNS is not reachable. In the tnsnames.ora file there is no reference to the Program Files (x86) directory.

Does anyone have any idea how I can get a 32 bit application using Oracle OLE DB provider to run on a 64 bit server?

Thank you!

Jeff M.