Catastrophic failure

[J. Marshall Latham]

I have written an ASP.NET web app in C# that is trying to connect to a
database using OleDb. I put code in a dll that uses another dll to create a
connection object (and open it if requested) to send back to the web app to
connect to the database.

I am getting the following error when I change anything in my web app and
recompile.
Catastrophic failure
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: Catastrophic failure

Stack Trace:

[OleDbException (0x8000ffff): Catastrophic failure]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr)
System.Data.OleDb.OleDbConnection.CreateProviderEr ror(Int32 hr)
System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString
constr)
System.Data.OleDb.OleDbConnection.Open()

I reset IIS to clear the problem (the only way that I have found other than
rebooting), and it will then work just fine. But if I adjust my code (the
web app not either of the dlls) and recompile, it will throw the
Catastrophic failure when I access the page. My coworker thought that it
might be because I was using a static module to create the connection, so I
adjusted the dll to be non-static. That did not solve the problem.

Is there anyway to prevent this failure, and is there anyway to clear this
error without having to restart IIS?

[Kevin Yu]

Hi Marshall,

I'd like to know what kind of database system you are working on? And
what's the version of it? If you are using a SQL Server, please try to
check the following link to get a workaround.

http://support.microsoft.com/default...b;en-us;243349

Or you can simply use a SQL server data provider to recover it.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: "J. Marshall Latham" <ma******@networkip.net>
| Subject: Catastrophic failure
| Date: Wed, 24 Sep 2003 16:06:01 -0500
| Lines: 37
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <uA**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.dotnet.general
| NNTP-Posting-Host: 24.204.3.242
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:109778
| X-Tomcat-NG: microsoft.public.dotnet.general
|
| I have written an ASP.NET web app in C# that is trying to connect to a
| database using OleDb. I put code in a dll that uses another dll to
create a
| connection object (and open it if requested) to send back to the web app
to
| connect to the database.
|
| I am getting the following error when I change anything in my web app and
| recompile.
| Catastrophic failure
| 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: Catastrophic failure
|
| Stack Trace:
|
| [OleDbException (0x8000ffff): Catastrophic failure]
| System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr)
| System.Data.OleDb.OleDbConnection.CreateProviderEr ror(Int32 hr)
| System.Data.OleDb.OleDbConnection.CreateProvider(O leDbConnectionString
| constr)
| System.Data.OleDb.OleDbConnection.Open()
|
|
|
| I reset IIS to clear the problem (the only way that I have found other
than
| rebooting), and it will then work just fine. But if I adjust my code (the
| web app not either of the dlls) and recompile, it will throw the
| Catastrophic failure when I access the page. My coworker thought that it
| might be because I was using a static module to create the connection, so
I
| adjusted the dll to be non-static. That did not solve the problem.
|
| Is there anyway to prevent this failure, and is there anyway to clear this
| error without having to restart IIS?
|
|
|
|

[J. Marshall Latham]

I am connecting to an Informix database. I believe it is 9.2. I don't
remember the version. I am using Informix ODBC and Invormix OleDb
drivers/providers.

JML
"Kevin Yu" <v-****@online.microsoft.com> wrote in message
news:nk**************@cpmsftngxa06.phx.gbl...

Hi Marshall,

I'd like to know what kind of database system you are working on? And
what's the version of it? If you are using a SQL Server, please try to
check the following link to get a workaround.

http://support.microsoft.com/default...b;en-us;243349

Or you can simply use a SQL server data provider to recover it.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Kevin Yu]

Hi Marshall,

I've done some research on this issue. This might be caused by the Informix
ODBC driver. Some certain versions of Informix ODBC driver isn't compatable
with Microsoft Transaction Server (MTS). That's why your IIS cannot connect
to the database. You can check it out at the following link:

http://support.microsoft.com/default...b;en-us;197815

Please try to contact Informix for a driver that supports MTS. If there
isn't one availabe, please try to revert it to an old version.

HTH

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
--------------------
| From: "J. Marshall Latham" <ma******@networkip.net>
| References: <uA**************@TK2MSFTNGP10.phx.gbl>
<nk**************@cpmsftngxa06.phx.gbl>
| Subject: Re: Catastrophic failure
| Date: Thu, 25 Sep 2003 08:24:49 -0500
| Lines: 27
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.dotnet.general
| NNTP-Posting-Host: 24.204.3.242
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:109851
| X-Tomcat-NG: microsoft.public.dotnet.general
|
| I am connecting to an Informix database. I believe it is 9.2. I don't
| remember the version. I am using Informix ODBC and Invormix OleDb
| drivers/providers.
|
| JML
|
|
| "Kevin Yu" <v-****@online.microsoft.com> wrote in message
| news:nk**************@cpmsftngxa06.phx.gbl...
| > Hi Marshall,
| >
| > I'd like to know what kind of database system you are working on? And
| > what's the version of it? If you are using a SQL Server, please try to
| > check the following link to get a workaround.
| >
| > http://support.microsoft.com/default...b;en-us;243349
| >
| > Or you can simply use a SQL server data provider to recover it.
| >
| > If anything is unclear, please feel free to reply to the post.
| >
| > Kevin Yu
| > =======
| > "This posting is provided "AS IS" with no warranties, and confers no
| > rights."
|
|
|

[John Eikanger [MSFT]]

Hi, Marshall

You might also check if there are more than one connections open using this
driver, If there are see if closing the first connection before opening
another resolves the problem. If so, this is likely due to a bug in the
informix/db2 driver.

Thank you for choosing the MSDN Managed Newsgroups,

John Eikanger
Microsoft Developer Support

This posting is provided “AS IS” with no warranties, and confers no rights.
"Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer’s security."
--------------------
| From: "J. Marshall Latham" <ma******@networkip.net>
| References: <uA**************@TK2MSFTNGP10.phx.gbl>
<nk**************@cpmsftngxa06.phx.gbl>
| Subject: Re: Catastrophic failure
| Date: Thu, 25 Sep 2003 08:24:49 -0500
| Lines: 27
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.dotnet.general
| NNTP-Posting-Host: 24.204.3.242
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:109851
| X-Tomcat-NG: microsoft.public.dotnet.general
|
| I am connecting to an Informix database. I believe it is 9.2. I don't
| remember the version. I am using Informix ODBC and Invormix OleDb
| drivers/providers.
|
| JML