problem connecting to datasource defined in freetds.conf

Patrick Kaeding <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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
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.