Re: Problems Connecting Debian --> MSSQL through odbc

Jaap van Arragon wrote:
> On 7/14/09 1:56 PM, "Frediano Ziglio" <[email protected]> wrote:
> > 2009/7/14 Jaap van Arragon <[email protected]>:
> >> 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