IBM Support

Unable to connect to Microsoft SQL Server via ODBC

Troubleshooting


Problem

Linux users are unable to connect to Microsoft SQL Server via ODBC when having multiple instances of SQL Server on the same SQL Server machine.

Symptom

Receive the following error message:
DSR.MetaGeta(GET.DSNINFO)(SQLConnect('SQLServer','ETL')) : BCI Error :
SQLSTATE=20117,CODE=11,[DataStage][SQL Client][ODBC][IBM(DataDirect
OEM)][ODBC SQL Server Driver][libssclient24]206112061120611
SQLSTATE=01000,CODE=0,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)]
[ODBC SQL Server Driver][libssclient24]ConnectionOpen (Name or service
not known()).

Cause

The 'Address' section in ODBC.INI is not properly configured as it will include the <Server Name (or IP address)>/<Instance Name>,<Port number> i.e.:
Address=MYSERVER\INSTANCE1,1433

Resolving The Problem

In the Address section of your odbc.ini file remove the port number for the SQL Server instance. Below is an example Address entry in the .odbc.ini file:

Address=MYSERVER\INSTANCE1

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"8.1;8.0.1;7.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 June 2018

UID

swg21409574

Page Feedback