topic Re: Specifying a range of ports in odbc.ini in Administration and Deployment

Specifying a range of ports in odbc.ini

SangaviS — Wed, 23 Dec 2020 12:37:32 GMT

We have got a situation where we have to enter DSN for an SQL database which uses dynamic ports. I tried specifying the range of ports using hyphen character like shown below but it gave an error. Can someone help me how we can specify range of ports inside odbc.ini?

Example: Port=1024-2048

Re: Specifying a range of ports in odbc.ini

alexal — Wed, 23 Dec 2020 12:49:20 GMT

What driver are you using? UNIX ODBC or Microsoft ODBC? Connecting to a dynamic port is supported only by Microsoft ODBC driver version 17.4 and higher, please see https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/connection-string-keywords-and-data-source-names-dsns?view=sql-server-ver15 and contact Microsoft if needed.

Re: Specifying a range of ports in odbc.ini

SangaviS — Wed, 23 Dec 2020 12:55:53 GMT

We are using unixODBC - FreeTDS. Thank you. This helps understand the situation. Are you aware of any workaround for this situation?

Re: Specifying a range of ports in odbc.ini

alexal — Wed, 23 Dec 2020 12:58:27 GMT

No, I'm not aware of any workarounds other than using Microsoft ODBC driver.

Re: Specifying a range of ports in odbc.ini

KS4NCS — Thu, 24 Dec 2020 08:19:57 GMT

Per FreeTDS documentation, you should use the instance name in the config.
http://www.freetds.org/userguide/freetdsconf.html#tab.freetds.conf