IT46668: THE SQL SERVER ODBC DRIVER ATTEMPTS TO VALIDATE SERVER CERTIFICATES EVEN WHEN THEY ARE NOT IN USE.

APAR status

• Closed as change to accomodate OEM Vendor's code.

Error description

• Unable to connect to an SQL Server database as the ODBC driver
  defaults to checking the server certificate even when
  certificates are not in use.
  

Local fix

Problem summary

• ****************************************************************
  
  USERS AFFECTED:
  All Users of IBM Integration Bus V10.1 and App Connect
  Enterprise V12
  
  
  Platforms affected:
  AIX, Linux on Power platform, Linux on x86-64 platform, Linux on
  
  zSeries platform
  
  ****************************************************************
  
  PROBLEM DESCRIPTION:
  Unable to connect to an SQL Server database from AIX or Linux
  using the DataDirect SQL Server ODBC driver. From App Connect
  Enterprise V12.0.12.2 the default behaviour of the ODBC driver
  has been changed so that it will now validate the database
  server certificate. If your environment is not using this form
  of validation then the attempt to connect to the database fails.
  
  To restore the ODBC driver to its previous default of not
  checking for a server certificate a new setting has to be added
  to each SQL Server data source stanza in the odbc.ini file. The
  new setting is ValidateServerCertificate=0.
  

Problem conclusion

• The odbc.ini template file, supplied as part of the product, has
  
  been updated to have ValidateServerCertificate=0 added.
  

Temporary fix

Comments

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