Re: E_UNEXPECTED(0x8000FFFF) Problem with OraOleDB.Oracle

On Oct 12, 2:15 am, Gubo <michal.gu..._at_gmail.com> wrote:
> On Oct 11, 4:21 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> > On Oct 11, 12:54 am, Gubo <michal.gu..._at_gmail.com> wrote:
>
> > > On Oct 11, 4:39 am, DA Morgan <damor..._at_psoug.org> wrote:
>
> > > > Gubo wrote:
> > > > > Hi everyone,
> > > > > I am developing a ASP.NET application (Framework 1.1) and since
> > > > > migration from Windows 2000 Server to Windows 2003 Server I have
> > > > > following problem:
>
> > > > > - Every now and then I get following exception:
> > > > > Exception: System.Data.OleDb.OleDbException
> > > > > Message: No error information available: E_UNEXPECTED(0x8000FFFF).
> > > > > at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
> > > > > at System.Data.OleDb.OleDbConnection.InitializeProvider()
> > > > > at System.Data.OleDb.OleDbConnection.Open()
>
> > > > > after receiving this exception the whole application hangs and has to
> > > > > be restarted. There is no way to open the connection to the DB until
> > > > > restart.
>
> > > > > connection string: Provider=OraOLEDB.Oracle;Data
> > > > > Source=mydb;pool=true;User ID=MYSCHEMA;Password=mypass
>
> > > > > did anyone have similar problem already ? Does anyone have any ideas ?
>
> > > > > thanks in advance
>
> > > > Not an Oracle issue.
>
> > > > I'd suggest you use Oracle's drivers instead.
> > > > --
> > > > Daniel A. Morgan
> > > > University of Washington
> > > > damor..._at_x.washington.edu (replace x with u to respond)
> > > > Puget Sound Oracle Users Groupwww.psoug.org
>
> > > I am using Oracle driver. "OraOLEDB.Oracle" is an Oracle OLEDB
> > > Provider. It comes from Oracle and not from Microsoft. The Microsoft
> > > provider would be MSDAORA.Oracle.
>
> > Post some useful information, then, such as the driver version. You
> > should also check the certification matrix for the Oracle driver
> > version you're using; I expect it isn't certified for use on Windows
> > Server 2003.
>
> > David Fitzjarrell
>
> Oracle OleDB Provider version 10.2.0.1
> Compatibility matrix on the metalink shows that the driver is
> compatible to Win 2003 and WIn 2003 R2.
>
> Michal Gubis

If I recall correctly, this problem has to do with the use of connection pooling. Try disabling connection pooling to see if the problem disappears.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Fri Oct 12 2007 - 10:54:22 CDT