Re: ASP.net and Oracle error System.Data.OleDb.OleDbException

First let me say, thanks for responding any assistance is greatly appreciated
I have been struggling with this for days and this project was supposed be go
live by today!

Yes I do use OracleInstance.GETBLANKETSTATUS.procListBlanketStatus
and my application does work on my computer but it does not work when I move
it to a web server.
This is my connection string:
"provider=MSDAORA; User Id=myUSER; Data Source=OracleDev;
Password=myPassword;"

Here is some of my connection code:
OleDbCommand cmBS = new OleDbCommand();
cmBS.Connection = oCn;
cmBS.CommandType = CommandType.StoredProcedure;
cmBS.CommandText =
"OracleInstance.PIMA_GETBLANKETSTATUS.pima_procListBlanketStatus";

OleDbDataAdapter daBS = new OleDbDataAdapter();
daBS.SelectCommand = cmBS;
daBS.AcceptChangesDuringFill = false;
daBS.Fill(DS,"BLANKET_STATUS");


I have created a test app with different providers and when I use
OraOLEDB.Oracle I get an error.
This is the connections string
"provider=OraOLEDB.Oracle; User Id=myUSER; Data Source=OracleDev;
Password=myPassword;"

This is the new error:
No error information available: REGDB_E_CLASSNOTREG(0x80040154).
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: No error information
available: REGDB_E_CLASSNOTREG(0x80040154).

Source Error:

Line 40: OleDbDataAdapter daBS = new OleDbDataAdapter();
Line 41: daBS.SelectCommand = cmBS;
Line 42: daBS.Fill(DS,"BLANKET_STATUS");
Line 43:
Line 44: //this.ugTest.DataBind


Source File: c:\inetpub\wwwroot\oraoledb_connection\webform1.aspx.cs
Line: 42

Stack Trace:

[OleDbException (0x80040154): No error information available:
REGDB_E_CLASSNOTREG(0x80040154).]

[InvalidOperationException: The 'OraOLEDB.Oracle' provider is not registered
on the local machine.]
System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr)
System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString
constr)
System.Data.OleDb.OleDbConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
OraOLEDB_Connection.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\oraoledb_connection\webform1.aspx.cs:42
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032




"Patrick.O.Ige" wrote:

> Is this how you use stored proc when using ORACLE "cmBS.CommandText =
> "OracleInstance.GETBLANKETSTATUS.procListBlanketStatus";
> "?
> And are you sure your connection string is ok.
>
>
> "petro" <petro@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:10986F0B-E9C5-44E3-9722-C806E24F219B@xxxxxxxxxxxxxxxx
> > Hello all,
> > My asp.net web application works on my machine but I get the following
> error
> > on our test web server, There is only one oracle home on the test server.
> > Does anyone know how to resolve this error?
> >
> > Oracle error occurred, but error message could not be retrieved from
> Oracle.
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information
> about
> > the error and where it originated in the code.
> >
> > Exception Details: System.Data.OleDb.OleDbException: Oracle error
> occurred,
> > but error message could not be retrieved from Oracle.
> >
> > Source Error:
> >
> >
> > Line 220: cmBS.CommandType = CommandType.StoredProcedure;
> > Line 221: cmBS.CommandText =
> > "OracleInstance.GETBLANKETSTATUS.procListBlanketStatus";
> > Line 222:
> > Line 223: OleDbDataAdapter daBS = new OleDbDataAdapter();
> > Line 224: daBS.SelectCommand = cmBS;
> >
> >
> > Source File: c:\inetpub\wwwroot\Myfile\myaspxpage.aspx.cs Line: 222
> >
> > Stack Trace:
> >
> >
> > [OleDbException (0x80004005): Oracle error occurred, but error message
> could
> > not be retrieved from Oracle.]
> > System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
> > System.Data.OleDb.OleDbConnection.InitializeProvider() +57
> > System.Data.OleDb.OleDbConnection.Open() +203
> > System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
> > ConnectionState& originalState) +44
> > System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
> > startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> > CommandBehavior behavior) +304
> > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecor
> d,
> > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
> > behavior) +77
> > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
> +36
> > WebReportMenu.BlanketContract.getData() in
> > c:\inetpub\wwwroot\webreportmenu\blanketcontract.aspx.cs:222
> > WebReportMenu.BlanketContract.Page_Load(Object sender, EventArgs e) in
> > c:\inetpub\wwwroot\webreportmenu\blanketcontract.aspx.cs:102
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +750
> >
> >
> >
> >
> > --------------------------------------------------------------------------
> ------
> > Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET
> > Version:1.1.4322.2032
> >
> >
>
>
>
.

Relevant Pages

  • Very strange SQL connection problem
    ... System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ... System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.adonet)
  • Server Error in /MyWebForm Application
    ... SQL connection in VS.NET 2003, I test the connection and everything works ... MSDE server. ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Deploying Web Service to my hosting services server
    ... It means that neither ODBC nor ... > connection, ConnectionState& originalState) ... > startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Very strange SQL connection problem
    ... Try creating a *new instance* of SqlConnection and then open and after the ... > connection string again and got the second exception after ... > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... And are you sure your connection string is ok. ... > on our test web server, There is only one oracle home on the test server. ... > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)