[freetds] cannot connect with tsql

Kevin Reed theeswashbuckler at gmail.com
Wed Jan 7 12:08:03 EST 2009


This could be problematic
i set the TDSVER as in the example shown, and tried all the values  
listed in the help pages(4.2, 5.0, 7.0, 8.0)
all of which created the same response.

which leads me to ask the question are there version of SQL server  
that freetds cannot connect to?
-kevin

On 6-Jan-09, at 4:51 PM, James K. Lowden wrote:

> Kevin Reed wrote:
>> tsql -H [ip address] -p 5000 -U uname -P password
>>
>> returns:
>> ocale is "en_CA.UTF-8"
>> locale charset is "UTF-8"
>> Msg 20017, Level 9, State -1, Server OpenClient, Line -1
>> Unexpected EOF from the server
>> Msg 20002, Level 9, State -1, Server OpenClient, Line -1
>> Adaptive Server connection failed
>> There was a problem connecting to the server
>>
>>
>> is this a security problem on the SQL server side or something
>
> http://www.freetds.org/userguide/serverthere.htm
>
> Set the TDSVER environment variable to the version you need, per the
> example.  It's not a permission problem.  The server is dropping the
> connection because the login packet is malformed, i.e., not what it's
> expecting.
>
> HTH.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list