OraOLEDB.Oracle provider is not registered
852761Apr 4 2011 — edited Jul 5 2011I'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!