Skip to Main Content

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!

OraOLEDB.Oracle provider is not registered

852761Apr 4 2011 — edited Jul 5 2011
I'm doing some local testing on a Windows 7 64-bit PC. I'm running Oracle 11g 64-bit locally. I'm trying to set up a connection to the Oracle database from a local ASP.NET application. When trying to make a connection to the database I get the error “The 'OraOLEDB.Oracle' provider is not registered on the local machine” (the application is blowing up at the line connection.Open() where I'm trying to connect using a connection string).

I added IIS_IUSRS to the Oracle Home directory and granted read, write, and execute permissions. I also successfully registered the OraOLEDB11.dll file through the command line. Those are a couple of fixes that I've found so far but my problem still persists.

I can connect to the Oracle database through SQL PLUS as well as SQL Developer. I've tried rebooting after making the changes that I've made so far. I've tried stopping and starting the database instance as well.

Does anybody else have any other ideas that I can try?

Thanks for any help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2011
Added on Apr 4 2011
5 comments
19,241 views