Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2005
    Posts
    11

    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.

    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”

  2. #2
    Join Date
    Feb 2005
    Posts
    11
    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.

  3. #3
    Join Date
    Jan 2006
    Posts
    27
    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

  4. #4
    Join Date
    Feb 2005
    Posts
    11
    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?

  5. #5
    Join Date
    Feb 2005
    Posts
    11
    Please help me!!!!

  6. #6
    Join Date
    Jan 2006
    Posts
    27
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •