I get a "CATASTROPHIC FAILURE" When doing another query after an ADO BEGINTRANS COMMITTRANS. The Unit of work commits properly, it just crashes the app when I try to use the connection again.

I have tried to close and re-open the connection, however that didn't help.

Some imformation:
Informix Version: 10.00.TC3
Operating System: WINXP SP2 (1 gig RAM)
OLEDB Provider: 2.90.TC3
ADO Connection String: “Provider=Ifxoledbc.2;Password=TASTESGREAT;User Id=APPLES;Data Source=SWIMPLATFORM@INFORMIX_DB;Persist Security Info=true;protocol=onsoctcp”

Just some more information. I am using IBM Informix client SDK, Date: 1 July 2005, Version: 2.90.xC3.

There was a know bug with Informix ODBC Driver, Date: 06/13/00 Version: 3.32.
Bug 127885
"CATASTROPHIC FAILURE" WHEN REQUERY AFTER ADO BEGINTRANS COMMITTRANS IF PASSING CONNECTION STRING WITH NO DSN

That was with the ODBC drive. I am not using ODBC, rather OLE DB. Someone please shed some light on this for me.

cJay, try using a DSN to odbc through the bridge. Frequently Oledb providers have a lot of code in common with ODBC Drivers.

Jay Grubb
Technical Consultant
OpenLink Software
Web: http://www.openlinksw.com:
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology Providers

John,

How do I use "DSN to ODBC through the bridge"? Are you referring to just using an ODBC connection? Is it not possible to still use OLE DB?

If it is still OLE DB, how would I change my connection string?

Please help me!!!!

Depends on the object (ie provider). In your string, Ifxoledbc.2

MS has a default one MSDASQL, the string would look like

Provider=MSDASQL;DSN=myodbc;uid=myid;pwd=mypwd

You'd use an odbc driver, with a DSN that can already connect. I've run into a problem in the past with with some transactions and transaction isolation levels leading to crashes.

I suggested a different direction to see if you can avoid them. Try the Informix provided Driver, or a 3rd party one. If the Informix one isn't the cure, try http://www.openlinksw.com.

Disclaimer, I work in tech support there. We have demo drivers available, and we will help you get them running.

Jay