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

user_457217 0
Viewed 16179

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?

freetds ruby-on-rails-3 sql-server
6 Answers

I encountered the same error. Then I did the following, and the error went away:

  1. pip install pyodbc
  2. Previously, I had used quotes for the DB server, username, and pwd in the TSQL command. This time, I removed the quotes.
user_113537860
Related