Search code examples
sql-serverruby-on-rails-3freetds

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?

Solution

  • To make this permenant I found I need to edit the freetds.conf file and set it globally in there

    vim /usr/local/freetds/etc/freetds.conf

    tds version = 8.0

    running tsql -C still showed that the version was 5.0 but connecting now worked every time.