Re: Problems Connecting Debian --> MSSQL through odbc

You're absolutely right! But the debian packages doesn't install tsql by
default so I needed to install freetds also from source.

I had multiple freetds.conf files.

I've found the right one and I can now connect through tsql.

BUT I can't connect through isql.

SERVER:# isql -v TEST -w
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect

Thanks for all the help!


On 7/14/09 2:40 PM, "James K. Lowden" <[email protected]> wrote:

> 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds