IBM Support

IC70272: V97FP3: ODBC ADMINISTRATOR(ODBCAD32.EXE) FOR 32 BIT IN A 64 BIT WINDOWS MACHINE IS NOT LISTING DEFAULT IBM DB2 ODBC DRIVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Odbc administrator(C:\WINDOWS\SysWOW64\odbcad32.exe) for 32 bit
    in a 64 bit windows machine is not listing default IBM DB2 ODBC
    DRIVER. Steps to reproduce the issue
    
    1) Launch C:\WINDOWS\SysWOW64\odbcad32.exe
    2) On "System DSN" tab, click on "Add". The list comes up does
    not contain the default odbc driver ie "IBM DB2 ODBC DRIVER"
    
    The reason could be - there is no registry entry for "IBM DB2
    ODBC DRIVER" in HKEY_LOCAL_MACHINE -> SOFTWARE -> Wow6432Node ->
    ODBC -> ODBCINST.INI
    
    but it is available for the 64 bit in
    
    HKEY_LOCAL_MACHINE -> SOFTWARE -> ODBC -> ODBCINST.INI
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * customers who want to use default copy name for 32 bit       *
    * binary in a 64 bit machine while creating system dsn         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * customers can not create system dsn using default copy name  *
    * for 32 bit binary in a 64 bit machine                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * move to 97fp3                                                *
    ****************************************************************
    

Problem conclusion

  • 97fp3 will have the fix. Customers can create system dsn using
    default copy name for 32 bit binary in a 64 bit machine
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70272

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-29

  • Closed date

    2010-09-20

  • Last modified date

    2010-09-20

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

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

    IZ81245

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 September 2010