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

Jaap van Arragon j.vanarragon at lukkien.com
Tue Jul 14 08:14:26 EDT 2009


I've tried it and the result was:

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

I've used the right login details because we're also connecting from a
apple(mac) workstation through ODBC and this is working so the login details
have to be correct.

Any more ideas?


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.
>> 
>> I've tested it with tsql and got this result:
>> 
>> 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>
>> 4>
>> 
>> Does this mean I van connect through TSQL but not through Isql?
>> 
> 
> This means that the computer and FreeTDS can connect to your server!
> 
> Try adding
> 
> TDS_Version=7.0
> 
> to GROUP section of your ini file. You can also try removing
> 
> Database = [327]
> 
> line
> 
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list