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

On Oct 12, 5:54 pm, Charles Hooper <hooperc2...@xxxxxxxxx> wrote:
On Oct 12, 2:15 am, Gubo <michal.gu...@xxxxxxxxx> wrote:



On Oct 11, 4:21 pm, "fitzjarr...@xxxxxxx" <fitzjarr...@xxxxxxx> wrote:
On Oct 11, 12:54 am, Gubo <michal.gu...@xxxxxxxxx> wrote:

On Oct 11, 4:39 am, DA Morgan <damor...@xxxxxxxxx> 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...@xxxxxxxxxxxxxxxx (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.

How do I disable connection pooling ? pool=false in connection string ?

.

Relevant Pages

  • Re: MSDTC and Oracle problem (ORA-00161)
    ... If your server is Windows 2003 Server: ... If your server is Windows XP contact PSS for QXP6. ... definitely ask for help on the Distributed transaction newsgroups, ... Oracle is the only RM that is involved in the transaction ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: oracle threads increasing, even after closing sessions
    ... We have a problem with 2 Oracle Server 10.2.0.0 on Windows 2003 ... activatinc DCD (Dead Connection Detection) may help, ...
    (comp.databases.oracle.server)
  • Re: oracle threads increasing, even after closing sessions
    ... We have a problem with 2 Oracle Server 10.2.0.0 on Windows 2003 ... activatinc DCD (Dead Connection Detection) may help, ...
    (comp.databases.oracle.server)
  • Re: mobile profiles with Oracle Connector
    ... this error appears only in mobile profiles, ... I save something in My documents but dont save this in mi server (moble ... change from win2k dont appears in windows XP or profiles server. ... Oracle Connector to access to server. ...
    (microsoft.public.windows.server.active_directory)
  • Re: oracle threads increasing, even after closing sessions
    ... We have a problem with 2 Oracle Server 10.2.0.0 on Windows 2003 ... after the user session is finished. ...
    (comp.databases.oracle.server)