problem connecting to datasource defined in freetds.conf

Posted by pkaeding on Server Fault See other posts from Server Fault or by pkaeding
Published on 2010-03-28T01:30:50Z Indexed on 2010/03/28 1:33 UTC
Read the original article Hit count: 600

Filed under:

freetds

|

sql-server

|

linux

I can connect successfully to my database using tsql when I bypass the freetds.conf file, like so:

% TDSVER=8.0 tsql -H 10.100.102.202 -p 1086 -U sa

After I enter my password, I am presented with a 1> prompt, and it is ready for my commands.

However, if I try to connect using the definition in my freetds.conf file, like this:

% tsql -S Millie -U sa

after entering my password, it seems to be trying to generate a prompt, but it just keeps counting. I will see 1, followed by 2, etc, without ever displaying a > character.

Here is what I have for my freetds.conf:

[global]
        # TDS protocol version
        tds version = 8.0
        text size = 64512

[Millie]
        host = 10.100.102.202
        port = 1086

What could be causing this anomaly?

If it helps, here is the output of tsql -C:

% tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v0.82
             freetds.conf directory: /usr/local/etc
     MS db-lib source compatibility: no
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 5.0
                              iODBC: no
                           unixodbc: no

Developer IT