problem connecting to datasource defined in freetds.conf
- by pkaeding
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