[freetds] Problems Connecting Debian --> MSSQL through odbc
James K. Lowden
jklowden at freetds.org
Tue Jul 14 08:40:08 EDT 2009
Jaap van Arragon wrote:
> On 7/14/09 1:56 PM, "Frediano Ziglio" <freddy77 at gmail.com> wrote:
> > 2009/7/14 Jaap van Arragon <j.vanarragon at lukkien.com>:
> >> Jep. I can ping to my host and I can connect through telnet on port
> >1433. >
> >> SERVER:# TDSVER=7.0 tsql -H IPADDRESS -p 1433 -U admin
> >> locale is "en_US.UTF-8"
> >> locale charset is "UTF-8"
> >> Password:
> >> 1>
> >> 2>
> >> 3>
>
> SERVER:# tsql -S TEST -U admin
> locale is "en_US.UTF-8"
> locale charset is "UTF-8"
> Password:
> There was a problem connecting to the server
In your first test, you set TDSVER=7.0 and it worked. In your second test
you did not, and it failed. That indicates that the TDS version is not
set in freetds.conf for server TEST.
I would double-check to make sure your freetds.conf is correct. If you
think it is but you still can't connect with tsql, set TDSDUMP or even
TDSDUMPCONFIG and examine the log. It will tell you the IP address of the
server it decided to use, and what version of the TDS protocol it used.
HTH.
--jkl
More information about the FreeTDS
mailing list