Incorrect lookup of interfaces entry with multiple host lines

"[email protected]" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Given an interfaces entry like (data below has been sanitized for security reasons):

> MYDBSERVER
> query tcp ether myhost 3001
> query tcp ether myhost 3002
> query tcp ether myhost 3003

Sybase native dblib/ctlib libraries will try and connect to the first entry (port 3001),
then if that times out, they'll connect to the 2nd entry, and so on.

But it looks like freetds is connecting to the *last* entry (port 3003).  From the TDBDUMPCONFIG
output:

> config.c:867:Interfaces file /export/home/sybase/clients-mssql/current/interfaces opened.
> config.c:877:Found matching entry for host MYDBSERVER
> config.c:900:host field myhost.
> config.c:900:host field myhost.
> config.c:900:host field myhost.
> config.c:918:Resolved IP as 'NNN.NNN.NNN.NN'.
> config.c:641:Setting 'tdsver' to 5.0 from $TDSVER.
> config.c:195:Final connection parameters:
> config.c:196: server_name = MYDBSERVER
> config.c:197: port = 3003

Is this a known bug/deficiency?

Thanks
Ben Slade
Near Washington DC
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.