Last post Apr 05, 2011 06:43 PM by Lannie
Apr 04, 2011 09:04 PM|driscoll|LINK
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 have any other ideas that I can try?
Thanks for any help!
Apr 05, 2011 06:43 PM|Lannie|LINK
Remove IIS_IUSRS from Oracle Home direction permissions, not needed.
OLEDB is 32-bit, install the Oracle 11g 32-bit client in another Oracle home directory. One way to do this is download 32-bit ODP.NET for 11g and do the CLIENT INSTALL when prompted at beginning of installation. ODP.NET contains the OLEDB drivers.