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()).
[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"8.1;8.0.1;7.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21409574