Question & Answer
Question
SQLServer is setup to dynamically assign ports. In the .odbc.ini file, the Address parameter is usually set to hostname colon port number (Address=HostName:1433), but the port may change. How should we handle this?
Answer
For the Address parameter value, instead of entering the hostname colon port, enter the hostname a backslash and the server instance name.
For example, in Unix/Linux, use the IBM SQLServer Wire Protocol driver and enter the following in the .odbc.ini file in the DSN definition for the connection to the SQLServer data source:
Address=HostName\Server_Instance_Name
For Windows, use the ODBC Data Sources Administrator to configure a System DSN for the data source using the IBM SQLServer Wire Protocol driver.
Note: The parameter is Server
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21460326