in reply to Re^16: install_driver(ODBC) mac mojave 10.14.2
in thread install_driver(ODBC) mac mojave 10.14.2

Try using version 7.3 in freetds.conf. What version of MSSQL Server ?

[MYMSSQL] host = servername.xxxx.xxxx.net port = 1433 tds version = 7.3
poj

Replies are listed 'Best First'.
Re^18: install_driver(ODBC) mac mojave 10.14.2
by raventheone (Novice) on Jan 25, 2019 at 14:40 UTC
    did adjust version to 7.3 but still no look. same error. DESKTOP-J2QR254:etc raventheone$ mysql --version mysql Ver 8.0.13 for osx10.14 on x86_64 (Homebrew)

      Seems strange that this works

      tsql -S servername.xxxx.xxxx.net -U username -P password -D dbname
      

      but this doesn't

      tsql -S MYMSSQL -U username -P password -D dbname

      Try enable logging and using just server name in freetds.conf

      # Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) [global] dump file = /tmp/freetds.log debug flags = 0xffff [MYMSSQL] host = servername.xxxx.xxxx.net
      poj
      mysql --version mysql Ver 8.0.13 for osx10.14 on x86_64 (Homebrew)

      mysql is not the same thing as MS SQL Server.

        how would i see the version installed?
        DESKTOP-J2QR254:etc raventheone$ sqlcmd -S Server -U user -P pw + Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open li +b 'ODBC Driver 17 for SQL Server' : file not found.