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

DESKTOP-J2QR254:etc raventheone$ tsql -C Compile-time settings (established with the "configure" script) Version: freetds v1.00.109 freetds.conf directory: /usr/local/etc MS db-lib source compatibility: no Sybase binary compatibility: yes Thread safety: yes iconv library: yes TDS version: 7.3 iODBC: no unixodbc: yes SSPI "trusted" logins: no Kerberos: yes OpenSSL: yes GnuTLS: no MARS: no

Replies are listed 'Best First'.
Re^17: install_driver(ODBC) mac mojave 10.14.2
by poj (Abbot) on Jan 25, 2019 at 13:25 UTC

    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
      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.