IBM Support

DataStage ODBC connection to SQL Server fails with SQLSTATE 01000, error 11.

Troubleshooting


Problem

DataStage ODBC connection to Microsoft SQL Server database with SSL enabled using driver VMmsss25.so fails with error: ODBC Function "SQLConnect" reported: SQLSTATE=01000: Native Erorr Code = 11: Msg = [IBM(DataDirect OEM)[ODBC SQL Server Legacy Driver][libssclient25]Connectionread(recv()).

Resolving The Problem

The ODBC drivers bundled with InfoSphere Information Server contain two SQL Server wire protocol drivers for Unix environments, the legacy driver VMmsssnn.so and the newer native driver VMsqlsnn.so (where "nn" is the version of driver, i.e. VMmsss24, VMmsss25, etc). The VMsqlsnn driver is the rcommended driver.

The SQLConnect connection error SQLSTATE 01000, Error code 11 is typically resolved by switching from the VMmsssnn driver to the VMsqlsnn driver. Please review the .odbc.ini file in the DSEngine directory and find the data source entry used in the failing connection. Change the driver= line to point to the correct VMsqlsnn driver for your release of DataStage (i.e. VMsqls24.so, VMsqls25.so, VMsqls00.so, etc).

Use the example DNS entry for this driver in the original odbc.ini file as a template for the correct set of properties to define for that driver.

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"11.3;8.5;8.7;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21966707

Page Feedback