Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

'OraOLEDB.Oracle.1' provider is not registered on the local machine

941596Jun 4 2012 — edited Mar 13 2013
Hello all,

I'm attempting to set up the 64-bit oledb driver (Oraoledb.Oracle) on a Windows 7 64-bit machine so that I can use in in my .NET application. I have downloaded the 64-bit Oracle Data Access Components from oracle.com and registered the OraOLEDB11.dll on my machine with regsvr32. However, when I attempt to use the provider in my .NET application, I still receive the "'OraOLEDB.Oracle' provider is not registered on the local machine" message. Any ideas or suggestions would be great. I'm really stumped on this......

Thanks,

Johnathan

Comments

941596
After some more research, I found the issue to my problem. In the readme.htm file that's included in the unzipped 64-bit providers folder, it explains that after you install the files through install.bat, you need to place the location you installed the files in the PATH variable for windows. For example, if you use the install.bat file to install the files at C:\Oracle, you need to place the paths "C:Oracle" and C:\Oracle\bin" in the PATH variable. You can find this variable by right-clicking on My computer and selecting Properties (for Windows Vista/7 users, it's right clicking on Computer then properties then advanced system settings). Click on the Advanced tab and click the Environment Variables button. In the Systems variables list, you'll find the PATH variable. I hope this helps someone else.... I worked on getting the oledb provider to work for days...

Thanks,

Johnathan
986944
Thanks, Jonathan, it helped. I was deploying SSIS package (which uses Oracle OLE DB provider) to a 64-bit environment and faced the same issue.
Wow, who new that old DOS-age path stuff still matters!
996743
HI Guys!

I have installed the 64 bit ORAOLEDB and I get the above message:

1. When I run it on my local machine it accesses the Oracle on another server successfully, but
2. When i deploy the c# app to another machine I get this error above.
2a. The other machines DSN test connection works fine.
3. I have set the environment PATH
4. I Have regsvr32'd the dll
5. I have re checked the permissions boxes

on the deployed machine, with no luck.

Im at a loss????

REgds

Paul
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 10 2013
Added on Jun 4 2012
#oracle-provider-for-ole-db, #windows-and-net
3 comments
97,526 views