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 number
IT40904
Reported component name
INTEGRATION BUS
Reported component ID
5724J0540
Reported release
A00
Status
CLOSED REQ
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-05-11
Closed date
2022-05-27
Last modified date
2022-05-27
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
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0"}]
Document Information
Modified date:
28 May 2022