-->

This article explains how to install the Microsoft ODBC Driver for SQL Server on macOS. It also includes instructions for the optional command-line tools for SQL Server (bcp and sqlcmd) and the unixODBC development headers.

Apr 09, 2014 Invalid order of free functions can cause crash (Bug# 17992912) Crash in ODBC Driver with CHARSET=WRONGCHARSET (Bug# 17999659) Driver and myodbc-installer crash with long option names (100) and values (255) (Bug# 17966018) ODBCManageDataSourcesQ4 cannot run MyODBC GUI setup to edit an existing; DSN (Bug# 18046123).
Mar 26, 2018 Microsoft Download Manager is free and available for download now. Back DirectX End-User Runtime Web Installer Next DirectX End-User Runtime Web Installer The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows, Linux, & macOS to Microsoft SQL Server and Microsoft Azure SQL Database.

This article provides commands for installing the ODBC driver from the bash shell. If you want to download the packages directly, see Download ODBC Driver for SQL Server.

Note

The Microsoft ODBC driver for SQL Server on macOS is only supported on the x64 architecture. The Apple M1 is not supported.

Feb 12, 2021 The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on macOS. Use the following commands to install the Microsoft ODBC driver 13.1 for SQL Server on OS X 10.11 (El Capitan) and macOS 10.12 (Sierra).

Microsoft ODBC 17

Free Odbc Driver For Mac Numbers Cheat

To install Microsoft ODBC driver 17 for SQL Server on macOS, run the following commands:

Important

If you installed the v17 msodbcsql package that was briefly available, you should remove it before installing the msodbcsql17 package. This will avoid conflicts. The msodbcsql17 package can be installed side by side with the msodbcsql v13 package.

Previous versions

The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on macOS.

ODBC 13.1

Use the following commands to install the Microsoft ODBC driver 13.1 for SQL Server on OS X 10.11 (El Capitan) and macOS 10.12 (Sierra):

Driver files

The ODBC driver on macOS consists of the following components:

Component	Description
libmsodbcsql.17.dylib or libmsodbcsql.13.dylib	The dynamic library (`dylib`) file that contains all of the driver's functionality. This file is installed in `/usr/local/lib/`.
`msodbcsqlr17.rll` or `msodbcsqlr13.rll`	The accompanying resource file for the driver library. This file is installed in `[driver .dylib directory]./share/msodbcsql17/resources/en_US/` for Driver 17 and in `[driver .dylib directory]./share/msodbcsql/resources/en_US/` for Driver 13.
msodbcsql.h	The header file that contains all of the new definitions needed to use the driver. Note: You cannot reference msodbcsql.h and odbcss.h in the same program. msodbcsql.h is installed in `/usr/local/include/msodbcsql17/` for Driver 17 and in `/usr/local/include/msodbcsql/` for Driver 13.
LICENSE.txt	The text file that contains the terms of the End-User License Agreement. This file is placed in `/usr/local/share/doc/msodbcsql17/` for Driver 17 and in `/usr/local/share/doc/msodbcsql/` for Driver 13.
RELEASE_NOTES	The text file that contains release notes. This file is placed in `/usr/local/share/doc/msodbcsql17/` for Driver 17 and in `/usr/local/share/doc/msodbcsql/` for Driver 13.

Resource file loading

The driver needs to load the resource file in order to function. This file is called msodbcsqlr17.rll or msodbcsqlr13.rll depending on the driver version. The location of the .rll file is relative to the location of the driver itself (so or dylib), as noted in the table above. As of version 17.1 the driver will also attempt to load the .rll from the default directory if loading from the relative path fails. The default resource file path on macOS is /usr/local/share/msodbcsql17/resources/en_US/

Free Odbc Driver For Mac Numbers List

Troubleshooting

Free Odbc Driver For Mac Numbers Free

Some users encounter an issue when trying to connect after installing the ODBC driver and receive an error like: '[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)'. It may be the case that unixODBC is not configured correctly to find registered drivers. In these cases, creating a couple symbolic links can resolve the issue.

Ceiling Fan Winding Calculation Okuma Alarm D List Helman CNC. HVAC and Refrigeration Compressor Troubleshooting Chart. Electrical Tool Electrical Notes amp Articles. Electrical Motor Winding Workshop Electrical Motor. Ceiling Fan Capacitor Solutions Conscious Junkyard. Subnautica An Underwater Exploration Game. Ceiling fan winding calculation pdf. Acces PDF Ceiling Fan Winding Calculation Ceiling Fan Winding Calculation As recognized, adventure as skillfully as experience nearly lesson, amusement, as well as concurrence can be gotten by just checking out a book ceiling fan winding calculation plus it is not directly done, you could tolerate even more in this area this life, nearly the world.

Free Odbc Driver For Mac Numbers Download

For additional cases where you are unable to make a connection to SQL Server using the ODBC driver, see the known issues article on troubleshooting connection problems.

Next steps

After installing the driver, you can try the C++ ODBC example application. For more information about developing ODBC applications, see Developing Applications.

For more information, see the ODBC driver release notes and system requirements.