IT37508: UNABLE TO MAKE AN ODBC CONNECTION TO SYBASE WHEN FORCED TO USE RSA PASSWORD ENCRYPTION.

APAR status

• Closed as program error.

Error description

• You have setup your Sybase database to force all clients to use
  RSA encryption for  passwords. When you try and make an ODBC
  connection these  errors are reported.
  
  BIP2322E: Database error: SQL State ''HY000''; Native Error Code
  '1640'; Error Text ''[unixODBC][IBM][ODBC Sybase Wire Protocol
  driver][Sybase ASE]Adaptive Server requires encryption of the
  login password on the network. ''.
  
  The error has the following diagnostic information: SQL State
  ''HY000'' SQL Native Error Code '1640' SQL Error Text
  ''[unixODBC][IBM][ODBC Sybase Wire Protocol driver][Sybase
  ASE]Adaptive Server requires encryption of the login password on
  the network. ''
  
  This message may be accompanied by other messages describing the
  effect on the integration node itself. Use the reason identified
  in this message with the accompanying messages to determine the
  cause of the error. Use the mqsicvp command to test connectivity
  to this database.
  
  BIP2322E: Database error: SQL State ''28000''; Native Error Code
  '4002'; Error Text ''[unixODBC][IBM][ODBC Sybase Wire Protocol
  driver][Sybase ASE]Login Failed. Check for valid user ID, server
  name and password.''.
  
  The error has the following diagnostic information: SQL State
  ''28000'' SQL Native Error Code '4002' SQL Error Text
  ''[unixODBC][IBM][ODBC Sybase Wire Protocol driver][Sybase
  ASE]Login Failed. Check for valid user ID, server name and
  password.''
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus 10.0 and IBM App Connect
  Enterprise 11.0 and 12.0 using ODBC connectivity and RSA
  password encrypton to connect to Sybase.
  
  
  Platforms affected:
  Windows on x86-64 platform, Solaris SPARC platform, Solaris
  x86-64 platform, Linux on x86-64 platform, Linux on Power
  platform, HP-UX Itanium platform, AIX
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When attempting to connect via ODBC to a Sybase database that
  only allows RSA encrypted passwords, the following errors were
  reported and the connection attempt failed:
  
  <span style="background-color:rgb(255, 255, 255)">BIP2322E:
  Database error: SQL State ''HY000''; Native Error Code</span>
  <span style="background-color:rgb(255, 255, 255)">'1640'; Error
  Text ''[unixODBC][IBM][ODBC Sybase Wire Protocol </span>
  <span style="background-color:rgb(255, 255, 255)">driver][Sybase
  ASE]Adaptive Server requires encryption of the  </span>
  <span style="background-color:rgb(255, 255, 255)">login password
  on the network. ''.                             </span>
  <span style="background-color:rgb(255, 255, 255)">
  
  </span>
  <span style="background-color:rgb(255, 255, 255)">The error has
  the following diagnostic information: SQL State  </span>
  <span style="background-color:rgb(255, 255, 255)">''HY000'' SQL
  Native Error Code '1640' SQL Error Text          </span>
  <span style="background-color:rgb(255, 255,
  255)">''[unixODBC][IBM][ODBC Sybase Wire Protocol driver][Sybase
      </span>
  <span style="background-color:rgb(255, 255, 255)">ASE]Adaptive
  Server requires encryption of the login password on</span>
  <span style="background-color:rgb(255, 255, 255)">the network.
  ''                                                </span>
  <span style="background-color:rgb(255, 255, 255)">
  
  </span>
  <span style="background-color:rgb(255, 255, 255)">This message
  may be accompanied by other messages describing the</span>
  <span style="background-color:rgb(255, 255, 255)">effect on the
  integration node itself. Use the reason identified</span>
  <span style="background-color:rgb(255, 255, 255)">in this
  message with the accompanying messages to determine the</span>
  <span style="background-color:rgb(255, 255, 255)">cause of the
  error. Use the mqsicvp command to test connectivity</span>
  <span style="background-color:rgb(255, 255, 255)">to this
  database.                                              </span>
  <span style="background-color:rgb(255, 255, 255)">
  
  </span>
  <span style="background-color:rgb(255, 255, 255)">BIP2322E:
  Database error: SQL State ''28000''; Native Error Code</span>
  <span style="background-color:rgb(255, 255, 255)">'4002'; Error
  Text ''[unixODBC][IBM][ODBC Sybase Wire Protocol </span>
  <span style="background-color:rgb(255, 255, 255)">driver][Sybase
  ASE]Login Failed. Check for valid user ID, server</span>
  <span style="background-color:rgb(255, 255, 255)">name and
  password.''.                                          </span>
  <span style="background-color:rgb(255, 255, 255)">
  
  </span>
  <span style="background-color:rgb(255, 255, 255)">The error has
  the following diagnostic information: SQL State  </span>
  <span style="background-color:rgb(255, 255, 255)">''28000'' SQL
  Native Error Code '4002' SQL Error Text          </span>
  <span style="background-color:rgb(255, 255,
  255)">''[unixODBC][IBM][ODBC Sybase Wire Protocol driver][Sybase
      </span>
  <span style="background-color:rgb(255, 255, 255)">ASE]Login
  Failed. Check for valid user ID, server name and     </span>
  <span style="background-color:rgb(255, 255, 255)">password.''
                                                     </span>
  

Problem conclusion

• The product includes an updated Sybase ODBC driver that resolves
  the problem.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.25
  v11.0      11.0.0.14
  v12.0      12.0.2.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

• Fixed component name

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels