var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OLE DB CRASH after CommitTrans
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.
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.
"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.
Universal Data Access & Virtual Database Technology Providers
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?
Depends on the object (ie provider). In your string, Ifxoledbc.2
MS has a default one MSDASQL, the string would look like
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.