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

[download]

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

    [download]
    poj
[reply]
[d/l]
      
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)

      [download]
[reply]
[d/l]

        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

        [download]
        poj
[reply]
[d/l]
        mysql --version
mysql  Ver 8.0.13 for osx10.14 on x86_64 (Homebrew)

        [download]

        mysql is not the same thing as MS SQL Server.

[reply]
[d/l]

In Section Seekers of Perl Wisdom