[freetds] Problems Connecting Debian --> MSSQL through odbc

Jaap van Arragon j.vanarragon at lukkien.com
Tue Jul 14 11:21:12 EDT 2009


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" <jklowden at freetds.org> wrote:

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




More information about the FreeTDS mailing list