IBM Support

IC74764: ODBC .NET CONNECTION FAILS USING 64-BIT DATA SERVER DRIVER DUE TO MIXTURE OF DB2APP64.DLL AND DB2CLIO.DLL

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The following stack will be seen in the Windows Event Viewer:
    
    Event Type: Error
    
    Event Source: COM+
    
    Event Category: Unknown
    
    Event ID: 4786
    
    Date: 2/23/2011
    
    Time: 11:50:31 AM
    
    User: N/A
    
    Computer: HOSTNAME
    Description:
    
    The system has called a custom component and that component has
    failed
    and generated an exception. This indicates a problem with the
    custom
    component. Notify the developer of this component that a failure
    has
    occurred and provide them with the information below.
    
    Component Prog ID: 0[ODBC][Env 1b233240]
    
    Method Name: IDispenserDriver::CreateResource
    
    Process Name: DB2call.exe
    
    Exception: C0000005
    
    Address: 0x000000001C0F796F
    
    Call Stack:
    
    DB2APP64!cryptDecryptBuffer + 0x14d8f5
    
    DB2APP64!cryptDecryptBuffer + 0xe6ada
    
    DB2APP64!cryptDecryptBuffer + 0xc88aa
    
    DB2CLIO!SQLSetConnectOption + 0x4a1c1
    
    DB2CLIO!SQLProcedures + 0x6390d
    
    DB2CLIO!SQLProcedures + 0x6755d
    
    DB2CLIO!SQLConnect + 0x2db2
    
    DB2CLIO!SQLConnect + 0x15e22
    
    DB2CLIO!SQLDriverConnectW + 0xcb1
    
    odbc32!SQLDisconnect + 0xf86
    
    odbc32!SQLFreeStmt + 0x2068
    
    comsvcs!DispManGetContext + 0xe53
    
    comsvcs!DispManGetContext + 0x2c41
    
    odbc32!SQLFreeStmt + 0x2c3e
    
    odbc32!SQLFreeStmt + 0x2e8d
    
    odbc32!SQLFreeStmt + 0x4496
    
    odbc32!SQLDriverConnectW + 0x1155
    
    mscorwks!IEE + 0xa90f
    

Local fix

  • To avoid this problem, the ODBC driver from a Client or Server
    install can be used instead of the Data Server Driver
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Applications using the ODBC .Net driver from the DB2 v9.7    *
    * Data Server Driver package                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ODBC .NET CONNECTION FAILS USING 64-BIT DATA SERVER DRIVER   *
    * DUE                                                          *
    * TO MIXTURE OF DB2APP64.DLL AND DB2CLIO.DLL                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 Fixpack 5                                *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 v9.7 Fixpack 5
    

Temporary fix

  • Use the ODBC driver from a full DB2 Client or Server install
    instead of the Data Server Driver
    

Comments

APAR Information

  • APAR number

    IC74764

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-03-01

  • Closed date

    2012-01-19

  • Last modified date

    2012-01-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC78561

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74764

Modified date: 19 January 2012