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.procListBlanketSta tus
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_procLis tBlanketStatus";
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.as px.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.CreateProviderEr ror(Int32 hr)
System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString
constr)
System.Data.OleDb.OleDbConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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.as px.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.procListBlanketSt atus";
"?
And are you sure your connection string is ok.
"petro" <pe***@discussions.microsoft.com> wrote in message
news:10**********************************@microsof t.com... 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.procListBlanketSt atus";
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(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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.a spx.cs:222
WebReportMenu.BlanketContract.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\webreportmenu\blanketcontract.a spx.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