Download ODBC Manager 1.0.19. 840 KB 64-bit only. Requires Mac OS 10.9 or later. Made for 64-bit ODBC drivers. Notarized and Gatekeeper compatible. Dec 26, 2018 Install Connector/ODBC: This is the official ODBC driver manager and driver from the Oracle website. You can configure ODBC using only odbc.ini, which contains the ODBC DSN details. You can optionally using odbcinst.ini as well but it is not needed. Microsoft® ODBC Driver 17 for SQL Server® - Windows, Linux, & macOS Important! Selecting a language below will dynamically change the complete page content to that language. You need an ODBC driver and ODBC manager application that handles the connection between the two workbooks. Microsoft supplies one ODBC driver with Office for Mac. It is the SQL Server ODBC driver that Neha referred to. As the name of the driver suggests, it works when using Microsoft SQL Server as a data source.
Similar to Windows, macOS utilizes named data sources (DSNs) for connecting ODBC-based client applications to Snowflake.
In this Topic:
Prerequisites¶Operating System¶
For a list of the operating systems supported by Snowflake clients, see Operating System Support.
iODBC¶
The Snowflake ODBC driver for Mac requires iODBC, which is available for download from:
To install iODBC:
Note
iODBC provides a GUI administrator tool for configuring drivers and DSNs; however, this tool has not been tested for use with Snowflake and, therefore, should not be used to create or manage DSNs. Use ODBC Manager instead.
ODBC Manager — Optional/Recommended¶
ODBC Manager is a GUI tool for configuring drivers and creating/managing DSNs. The tool is optional because you can also create DSNs manually by editing the appropriate
odbc.ini file. ODBC Manager is available from:
To install ODBC Manager:
The installer installs ODBC Manager in the
~/Applications/Utilities directory.
Step 1: Install the ODBC Driver¶
To install the Snowflake ODBC driver for macOS:
If you choose the default directory when prompted, the installer installs the ODBC driver files in the following directories:
Step 2: Configure the ODBC Driver¶
To configure the ODBC driver for macOS, create one or more data source (DSNs), which are stored in the following files, depending on the type of DSN you create:
To create a DSN, either use ODBC Manager or edit the appropriate
odbc.ini file.
Creating a DSN Using ODBC Manager¶
To create a DSN in ODBC Manager:
If you are creating the first user or system DSN for the ODBC driver, ODBC Manager creates the
odbc.ini file in the corresponding directory for the type of DSN you are creating. If you are creating additional DSNs, ODBC Manageradds entries for each DSN to the existing odbc.ini file.
Driverpack Solution For Windows 7Creating a DSN by Adding an Entry in the
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |