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



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.

.



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)
  • Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... I posted this question in the .server newsgroup yesterday, but apparently my cross-post to this newsgroup didn't made it, so now I post it once more. ... I'm having some troubles setting up an Oracle datasource on a SSIS ... Since this Provider isn't available in the 64-bit version I ... I'd love to uninstall both Oracle clients and then try just to install ...
    (microsoft.public.sqlserver.dts)
  • 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)