JR34996: PROBLEM WITH DRS/ODBC SQL SERVER ON SOLARIS IS 8.1

APAR status

• Closed as program error.

Error description

• When running IS 8.1 on Solaris with the DRS/ODBC driver to
  connect to SQL server.
  
  When running a simple PX jobs using the DRS stage, they are
  getting the following warning messages appearing:
  APT_CombinedOperatorController,0: Warning:
  [DataDirect][ODBC SQL Server Driver][SQL Server]The DataDirect
  ODBC driver you are attempting to access has been provided to
  you by IBM Corporation for exclusive use with IBM Information
  Server.  You are not licensed to use this driver with any
  application other than IBM Information Server.  If you would
  like to purchase a driver for some other use, please call
  800-876-3101 or visit DataDirect at www.datadirect.com
  and an entry QEWSD=xxxxx appears in the .odbc.ini file
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of DRS Plugin in Infromation Server v8.1 on 64 bit
  Solaris.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Customer received this message when trying to run a job with the
  DRS Plugin and and an entry QEWSD=xxxxx
  appears in the .odbc.ini file.
  
  APT_CombinedOperatorController,0: Warning:
  [DataDirect][ODBC SQL Server Driver][SQL Server]The DataDirect
  ODBC driver you are attempting to access has been provided to
  you by IBM Corporation for exclusive use with IBM Information
  Server.  You are not licensed to use this driver with any
  application other than IBM Information Server. If you would
  like to purchase a driver for some other use, please call
  800-876-3101 or visit DataDirect at www.datadirect.com
  ****************************************************************
  RECOMMENDATION:
  Install the patch patch_JR34996_server_solaris_8100.tar.
  ****************************************************************
  

Problem conclusion

• The license file DDVM.LIC was added for 64-bit platforms for the
  branded_ODBC at SQLCONNECT.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSY

     UP