Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

FreeTDS problem connecting to SQL Server on Mac (Unexpected EOF from the server)

I have setup FreeTDS to connect to SQL Server database. When I try to open TSQL in terminal on Mac (lion) I get this error:

locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Error 20017 (severity 9):
    Unexpected EOF from the server
    OS error 36, "Operation now in progress"
Error 20002 (severity 9):
    Adaptive Server connection failed
There was a problem connecting to the server

Does anybody have a clue what could be causing this?

like image 533
gugguson Avatar asked Aug 07 '11 14:08

gugguson


1 Answers

I think I got it, it's the TDS configured version, I had 5.0, which caused the error

Try running tsql -C to check what version are you using, and then you can invoke tsql overriding the version with:

TDSVER=7.0 tsql -H hostname -p port -U domain\\\username -P password

and it worked!

like image 78
gabouy Avatar answered Sep 22 '22 03:09

gabouy