Last post Jul 16, 2013 10:05 AM by moncheri_chat
Jul 10, 2013 03:52 PM|jwang592|LINK
I have created a website that has an oracle connection in it that works when I launch it in Visual Web Developer Express. However, when I launch the site from the server on IIS 7, I get
The 'OraOleDB.Oracle' provider is not registered on the local machine.
I am on a 64-bit machine. I have the 64-bit OLE DB Oracle driver installed and registered (using regsvr32 that everyone mentions) as well as security rights for IIS_USERS. My current connection string is below:
<add name="TDRP" connectionString="Provider=OraOleDB.Oracle;Data Source=TDRP;Persist Security Info=True;Password=********;User ID=*****; providerName="System.Data.OleDb" />
Am I approaching this problem correctly? I saw a number of different formats for connection strings as well as using provider name "system.data.oracleclient" instead of "system.data.oledb." Also, should my data source be .NET Framework Data Provider for
OLE DB or Oracle Database?
Thank you in advance!
Jul 16, 2013 10:05 AM|moncheri_chat|LINK
You can try to register the OraOleDB provider in HKEY_LOCAL_MACHINE.
Open REGEDIT.exe -> HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft -> Microsoft SQL Server -> MSSQL10 -> Providers
if tehre is not an ORAOLEDB.Oracle Key, then create it and add a new value called "AllowInProcess" with value=1
Hope this helps.