- Free Odbc Driver For Mac Numbers Software
- Free Odbc Driver For Mac Numbers Cheat
- Free Odbc Driver For Mac Numbers Update
- Free Odbc Driver For Mac Numbers Download
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.
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.
Actual ODBC Pack (for Mac OS - compatible with MacOS 11 Big Sur) The Actual ODBC Pack installs the latest version of several Actual Technologies ODBC drivers. The included drivers and their version numbers are listed below. MySQL ODBC driver (32/64 bit) v.2.1 Devart ODBC Driver for MySQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MySQL databases from Windows, Linux and Mac OS X, both 32-bit and 64-bit.
Amazon Redshift provides ODBC drivers for Linux, Windows, and macOS X operating systems. Before you install an ODBC driver, determine whether your SQL client tool is 32-bit or 64-bit. Install the ODBC driver that matches the requirements of your SQL client tool. Otherwise, the connection doesn't work. 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). Open the ODBC Administrator Tool. Click the Drivers tab, and then select the driver named 'Vertica.' Click the Configure button. A dialog box opens. In Description, enter a new name for the driver, and then click OK. The dialog box closes. On the ODBC Administrator.
Note
The Microsoft ODBC driver for SQL Server on macOS is only supported on the x64 architecture. The Apple M1 is not supported.
Microsoft ODBC 17
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/
Troubleshooting
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.
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.
December 17, 2020
Actual Announces Native Apple Silicon Drivers
Actual Technologies today announced that the latest versions of the Actual ODBC Drivers are Universal Binaries that are compatible with both Intel-based Macs and the new super fast Apple Silicon-based Macs. The Actual ODBC drivers are recommended for use with FileMaker 19 and Microsoft Excel 365 on MacOS Catalina and Big Sur. Version 5.1 licenses are available at a discount for version 4 users. The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
May 20, 2020
Actual Announces FileMaker 19 Compatibility
Actual Technologies today announced that the latest versions of the Actual ODBC Drivers are recommended for use with Claris FileMaker 19. Actual ODBC Pack version 5 features full compatibility with FileMaker 19, Microsoft Excel 2016 (part of Microsoft Office 365), and Mac OS Catalina. Version 5 licenses are available at a discount for version 4 users. The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
October 7, 2019
Actual ODBC is Compatible with Catalina
The latest Actual ODBC Pack is compatible with Apple's latest Mac OS 10.15 Catalina. Version 5 features full compatibility with FileMaker 18, Microsoft Excel 2016 (part of Microsoft Office 365), and Mac OS Catalina. The new version also includes numerous performance and stability enhancements, as well as support for future versions of Mac OS. Version 5 licenses are available at a discount for version 4 users. The Actual ODBC Pack installer is available now from the Actual Technologies website.
September 4, 2019
Actual Announces Actual ODBC Pack 5.0
Actual Technologies today announced the introduction of version 5.0 of their acclaimed ODBC drivers. Version 5 features full compatibility with FileMaker 18, Microsoft Excel 2016 (part of Microsoft Office 365), and Mac OS Mojave. The new version also includes numerous performance and stability enhancements, as well as support for future versions of Mac OS. Version 5 licenses are available at a discount for version 4 users. The Actual ODBC Pack installer is available now from the Actual Technologies website.
May 22, 2019
Actual Announces FileMaker 18 Compatibility
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 18. The upgrade is free for users who already have a Version 4 license key (version 3 users can upgrade at a discount). The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
May 15, 2018
Actual Announces Actual ODBC Pack 4.2.0 for FileMaker 17
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 17. The upgrade is free for users who already Have a Version 4 license key (version 3 users can upgrade at a discount). The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
May 9, 2017
Actual Announces Actual ODBC Pack 4.1.0 for FileMaker 16
Free Odbc Driver For Mac Numbers Software
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 16. The upgrade is free for users who already Have a Version 4 license key (version 3 users can upgrade at a discount). The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
August 26, 2016
Actual ODBC Compatible with 64-bit Excel
Microsoft has released a 64-bit version of Excel 2016 for Mac (version 15.25). This new version of Excel requires the latest versions of the Actual ODBC Pack drivers in order to avoid a crash. The Actual ODBC Pack installer is available now from the Actual Technologies website.
May 10, 2016
Actual Announces ODBC Pack 4.0
Actual Technologies today announced the introduction of version 4.0 of their acclaimed ODBC drivers. Version 4 features full compatibility with FileMaker 15, Microsoft Excel 2016, and Mac OS X El Capitan. The new version also includes numerous performance and stability enhancements, as well as new features like support for .XLSX files with the Actual Access driver. The Actual ODBC Pack installer is available now from the Actual Technologies website.
May 10, 2016
Actual ESS Adapter Now Available
Actual Technologies today released a new product for connecting FileMaker solutions to Postgres and IBM DB2 databases. Developers already use Actual Technologies ODBC drivers for MySQL, Oracle, and Microsoft SQL Server with the 'External SQL Sources' (ESS) feature of FileMaker. The Actual ESS Adapter broadens the types of databases which can be used with ESS. Licenses are free for Mac OS X, and start at $39.95 per PC for Windows users. The Actual ESS Adapter installer is available now from the Actual Technologies website.
September 30, 2015
Actual Announces 'El Capitan' Compatibility for Actual ODBC Pack
Actual Technologies today announced that the latest versions of the Actual ODBC Drivers are compatible with Mac OS X 10.11 'El Capitan'. The latest Actual ODBC Pack installer should be run after upgrading to El Capitan to ensure compatibility between your application and the drivers.
July 12, 2015
Actual Announces Support for Microsoft Excel 2016
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are are compatible with Excel 2016. The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
May 12, 2015
Free Odbc Driver For Mac Numbers Cheat
Actual Announces Actual ODBC Pack 3.3.0 for FileMaker 14
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers are recommended for use with FileMaker 14. The latest Actual ODBC Pack installer is available now from the Actual Technologies website.
October 16, 2014
Actual Announces Yosemite Compatibility for Actual ODBC Pack
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers work great with Mac OS X 10.10 'Yosemite'. The latest Actual ODBC Pack installer should be run after upgrading to Yosemite to ensure compatibility between your application and the drivers.
October 24, 2013
Actual Announces Actual ODBC Pack 3.2 for Mavericks
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers work great with Mac OS X 10.9 'Mavericks'. The latest Actual ODBC Pack installer should be run after upgrading to Mavericks to ensure compatibility between your application and the drivers.
July 25, 2012
Actual ODBC Drivers Have Gatekeeper Support on Mountain Lion
Actual Technologies today announce that the latest versions of the Actual ODBC Drivers work great with Mac OS X 10.8 'Mountain Lion'. The Actual ODBC Pack installer is built to work with the new Gatekeeper security feature of Mountain Lion.
April 4, 2012
Actual Announces Actual ODBC Pack 3.1 for FileMaker 12
Actual Technologies today released the Actual ODBC Pack version 3.1. The drivers fully support the new 64-bit FileMaker Server 12 released today. FileMaker 12 includes support for Microsoft SQL Server 2008, Oracle 11g and MySQL 5.1. You can use our drivers with any of the databases supported by FileMaker. Download and try the new drivers today.
July 20, 2011
Actual ODBC drivers on Lion!
The latest Actual ODBC Pack version 3.0 includes support for Apple's Mac OS X 10.7 'Lion'. The drivers also work great with Microsoft Excel 2011. Visit our download page to get running with the latest drivers.
March 9, 2010
Actual Announces Actual ODBC Pack 3.0 for FileMaker 11
Actual Technologies today released the Actual ODBC Pack version 3.0. The drivers now fully support 64-bit applications, such as Apache / PHP on Snow Leopard. The new driver versions also support the latest External SQL Source (ESS) features of FileMaker 11. FileMaker 11 includes support for Microsoft SQL Server 2008, Oracle 11g and MySQL 5.1. You can download and try the new drivers today.
January 5, 2009
Actual ODBC Supports Latest FileMaker Pro 10 External SQL Sources
Actual Technologies today released the Actual ODBC Pack version 2.9. The new driver versions support the latest External SQL Source (ESS) features of FileMaker 10. FileMaker 10 now includes support for Microsoft SQL Server 2008, Oracle 11g and MySQL 5.1. You can download and try the new drivers today.
July 10, 2007
Actual ODBC Supports New FileMaker Pro 9 External SQL Sources
Actual Technologies today released the Actual ODBC Pack version 2.7, a set of database drivers for Mac OS X. The drivers are tailored for use with the new External SQL Source (ESS) feature of FileMaker Pro 9. With Actual ODBC, FileMaker Pro 9 users can view and update live data in Microsoft SQL Server, Oracle and MySQL databases without writing SQL code. The drivers are available starting at $30 per license. To purchase the software or download an evaluation copy, please visit http://www.actualtech.com.
Free Odbc Driver For Mac Numbers Update
January 9, 2006
Actual releases ODBC Pack 2.0 drivers
Actual Technologies has released the Actual ODBC Pack 2.0, a suite of ODBC drivers designed to connect to popular databases. The new drivers are distributed as Universal Binaries for compatibility with both PowerPC Macs as well as Intel-based Macs, and are designed specifically for Mac OS X.
Free Odbc Driver For Mac Numbers Download
Each member of the ODBC pack connects Excel X to a database back-end, without the need for programming knowledge while allowing users to import from FileMaker Pro. Supported databases include SQL Server/Sybase, Oracle, MySQL/PostgreSQL and Microsoft Access.
Each database driver is available for $30, and requires Mac OS X 10.2.4 or later.