Re: Specifying a range of ports in odbc.ini

SangaviS · Posted 12-23-2020 07:37 AM

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

alexal · Posted 12-23-2020 07:49 AM

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-sour... and contact Microsoft if needed.

SangaviS · Posted 12-23-2020 07:55 AM

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

alexal · Posted 12-23-2020 07:58 AM

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

KS4NCS · Posted 12-24-2020 03:19 AM

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