Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
- From: "petro" <petro@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 21 Nov 2005 07:42:12 -0800
We got it working! The system admisinstrator downloaded the current MDAC and
uninstalled and reinstalled Oracle and now it works. Thanks for your replies.
"Eric" wrote:
> 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
> >
> >
>
>
>
.
- References:
- Prev by Date: Re: Datagrid ItemDatabound event ??
- Next by Date: Re: streamreader will not read UK pound sign!!!
- Previous by thread: Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
- Next by thread: What materials ?
- Index(es):
Relevant Pages
|
Loading
