IT40904: ADD SUPPORT FOR ODBC ACCESS TO SQL SERVER USING AZURE ACTIVE DIRECTORY AUTHENTICATION.

APAR status

• Closed as requirement.

Error description

• BIP2322E: Database error: SQL State ''HY000''; Native Error Code
  '2733'; Error Text ''[unixODBC][IBM][ODBC SQL Server Wire
  Protocol driver]Unable to dynamically load client DLL
  libUKcurl95.so.''. The error has the following diagnostic
  information: SQL State ''HY000'' SQL Native Error Code '2733'
  SQL Error Text ''[unixODBC][IBM][ODBC SQL Server Wire Protocol
  driver]Unable to dynamically load client DLL libUKcurl95.so.''
  and
  
  BIP2322E: Database error: SQL State ''HY000''; Native Error Code
  '0'; Error Text ''[unixODBC][IBM][ODBC SQL Server Wire Protocol
  driver]Failed to authenticate the user 'xxxx@xxxxxxxx' in Active
  Directory (Authentication Method is '13 - Active Directory
  Password').''. The error has the following diagnostic
  information: SQL State ''HY000'' SQL Native Error Code '0' SQL
  Error Text ''[unixODBC][IBM][ODBC SQL Server Wire Protocol
  driver]Failed to authenticate the user 'xxxx@xxxxxxxx' in Active
  Directory (Authentication Method is '13 - Active Directory
  Password').''
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus V10 and App Connect Enterprise
  V11 and V12 who wish to access an SQL Server database using
  Azure Active Directory for authentication.
  
  
  Platforms affected:
  AIX, HP-UX Itanium platform, Linux on Power platform, Linux on
  x86-64 platform, Linux on zSeries platform, Solaris x86-64
  platform, Solaris SPARC platform, Windows on x86-64 platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  The DataDirect ODBC driver library needed to allow Azure Active
  Directory authentication is not supplied with IBM Integration
  Bus or App Connect Enterprise preventing this functionality from
  working.
  

Problem conclusion

• The extra library needed has been added to the package of ODBC
  drivers shipped with IBM Integration Bus and App Connect
  Enterprise.
  

Temporary fix

Comments

• ADD SUPPORT FOR ODBC ACCESS TO SQL SERVER USING AZURE ACTIVE
  DIRECTORY AUTHENTICATION
  

APAR Information

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

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

Fix information

Applicable component levels