Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
- From: "Eric" <emfortin@xxxxxxxxxxx>
- Date: Sat, 19 Nov 2005 07:41:27 -0700
It sounds like you need to download the oraoledb driver from oracle and
install it on the server
The oledb driver is not part of the 'standard' oracle client install
package... It is only installed when you choose custom or a 'developer' type
install
The easiest way to tell if it's installed: go to start -> programs ->
oracle home x.xx -> application development -> OraOLEDB
Documentation.html... if that link does not exist, you don't have the driver
installed... (Of course there are other ways to figure it out, but that's
what I check first)
Go to technet.oracle.com and find your way to driver downloads... If you
have the client installation cd, you can probably custom install it from
there.... It Oledb for oracle is also installed when you install their .net
suite of tools...
If you can use oraoledb, I would stick with it; OO4O and ODP.net are better
for accessing oracle, but neither are easily portable to other db's (whereas
oracle's ole db driver is--codewise at least)....
"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
> startRecord,
> 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
>
>
.
- Follow-Ups:
- Prev by Date: Re: update to asp.net 2 only for one single website
- Next by Date: Re: How to name BoundColumn to set Visible flag in Code Behind?
- Previous by thread: Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
- Next by thread: Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
- Index(es):
Relevant Pages
|
