Unable to connect to SQL Server from Mac OSX

[GianlucaGuarroSonos]

Environment

• Python:
• pyodbc:
• OS: Mac OSX (Apple Silicon)
• DB: SQL Server
• driver: ODBC Driver 18 for SQL Server

Issue

I am trying to follow the guide for connection to SQL Server from Mac OSX

And when I test the connection with tsql -S MYMSSQL -U myuser -P mypassword (obviously using my actual credentials), it counts to 75 seconds and outputs the following error:

75Error 20009 (severity 9):
    Unable to connect: Adaptive Server is unavailable or does not exist
    OS error 60, "Operation timed out"

One thing I noticed that may be a cause for concern is that after I installed freetds, homebrew put my freetds.conf file in /opt/homebrew/etc. The guide says "Ensure the freetds.conf file is located in directory /usr/local/etc/" which is not the case for me.

Could someone tell me what it is that is going wrong?

[v-chojas]

Check what driver you're actually using in your DSN. The Microsoft ODBC Driver for SQL Server doesn't give such messages, so it looks like you're using the wrong driver.

[gordthompson]

"Unable to connect: Adaptive Server is unavailable or does not exist" is a FreeTDS error message, and tsql is a FreeTDS utility.