JR63328: ODBC CONNECTOR JOBS ABORT WHILE USING A SINGLE CHARACTER ODBC DSN NAME

APAR status

• Closed as program error.

Error description

• ODBC Connector jobs fail to connect while using a single
  character ODBC DSN name. The following error message is thrown
  at that time:
  
  ##E IIS-CONN-ODBC-00229 13:26:39(008)
  <ODBC_Connector_0> The connector could not establish a
  connection to data source using user <USERNAME>.
  
  ##E
  IIS-CONN-ODBC-00004 13:26:39(009) <ODBC_Connector_0> ODBC
  function "SQLConnect" reported: SQLSTATE = IM002: Native Error
  Code = 0: Msg = [DataDirect][ODBC lib] Data source name not
  found and no default driver specified
  (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line
  592)
  

Local fix

• Use multi-character ODBC DSN name.
  

Problem summary

• ODBC Connector jobs abort while using a single character ODBC
  DSN name
  

Problem conclusion

• Code has been corrected to overcome this problem.
  

Temporary fix

• Use a multi-character ODBC DSN name.
  

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