The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.]
318300Jul 6 2005 — edited Jul 30 2010I have a new installation of Microsoft Windows Server 2003 Standard Edition Service Pack 1. The version of IIS is 6.0. I am running the Oracle9i Client 9.0.1.1.1.
ADODB with asp works great.
OraOLEDB with aspx does not. I get the following stack trace:
OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).]
[InvalidOperationException: The 'OraOLEDB.Oracle.1' provider is not registered on the local machine.]
System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) +82
System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
oracleTest.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\oracletest\webform1.aspx.cs:42
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
I have given the aspnet user, the iusr_machine, and the iwam_machine account full control of my oracle directory. All others machine/users have read & execute privileges.
Any ideas?
Thanks
Janet Mesina