Configuring the ODBC Driver on macOS to connect to Microsoft SQL Server

Explain additional configurations on macOS to connect to Microsoft SQL Server.

To set up macOS machines to connect to Microsoft SQL Server, do the following:

  1. On your macOS machine, install Homebrew.

    Homebrew is a package manager for macOS.

  2. Install the ODBC driver, which is FreeTDS.

    FreeTDS is a set of libraries that allows your programs to natively talk to Microsoft SQL Server.

    • On macOS 10.11, 10.10: At a Terminal prompt, execute the following command.

      brew install freetds --with-libiodbc
      
  3. Modify your odbcinst.ini file, located at /Users/test/Library/ODBC/, by adding the following line.

    [SQL Server]
    Driver = /usr/local/Cellar/freetds/1.00.21/lib/libtdsodbc.so
    

Copyright © 2024 LogiGear Corporation. All rights reserved. LogiGearはLogiGear Corporationの登録商標であり、Action Based TestingおよびTestArchitectはLogiGear Corporationの商標です。ここに記載されているその他の商標は、各所有者の財産です。

LogiGear Corporation

1730 S. Amphlett Blvd. Suite 200, San Mateo, CA 94402

Tel: +1 (650) 572-1400