Prerequisites
Actual ODBC for Claris FileMaker 19! Version 5.0 of the Actual ODBC Pack is compatible with the latest Claris FileMaker 19 and MacOS Catalina. The Actual ODBC Pack installer is available from our website. An upgraded license key is required. Microsoft Excel on the Mac is also quite popular and many of us have wondered when Microsoft will come out with a full version of Pivot Tables on Mac Excel. The Simba ODBC drivers on the Mac include Hive, HBase, Cassandra, and MongoDB. Some of these drivers are already in production like the Hive Mac ODBC driver we have with Hortonworks.
ODBC Driver for SQLite works under control of an ODBC driver manager. ODBC driver manager is not distributed along with our driver and must be installed separately.
ODBC Driver for SQLite is compatible with iODBC driver manager.
In case when using other ODBC driver managers, ODBC Driver for SQLite will be installed, but it will require manual modification of configuration files of these managers.
Installation
- Download the PKG file from the Devart website.
- Run the downloaded file and follow the instructions in the wizard.
- After reading the license agreement, click Agree to proceed with the installation.
- In the License Information dialog box, you should select the license type and activate the product. If you have no activation key, you can select Trial and use the driver for evaluation purposes.
- If you have an activation key, select the Activation Key option. Copy the activation key from the registration email or your Customer Portal account and paste it into the Activation Key edit box.
- If you have the activation key file, click the Load Activation Key button and browse to it.
- Click Continue.
- Click Install.
- Driver is installed successfully.
![For For](https://wiki.freepascal.org/images/3/39/WinXPODBCDataSourceAdministratorDrivers.png)
To activate the driver, perform the steps described in the Product Activation article.
Test connection
After the driver is installed, DSN with the name DEVART_SQLITE is created. You can use it to test a connection with SQLITE server. For this, perform the following steps:
- Run the iODBC utility of the required bitness. Find the DEVART_SQLITE section and click the Configure button:
- In the appeared dialog, specify the required connection settings and click OK.
- Now click the Test button to establish a test connection to your data source.
Using Client Library with SIP enabled
![Odbc driver download for mac Odbc driver download for mac](https://static.macupdate.com/screenshots/268012/m/openlink-express-odbc-driver-for-sybase-screenshot.png?v=1593139700)
When SIP is enabled on your machine, put the client library file in either of these directories and specify the path to the client library in the Client Library connection parameter.
- /Applications
- /Library
- /usr/local
If you place the client library in either of the following directories when SIP is enabled, the driver will not be able to access the library due to protection for these parts of the system by SIP.
- /System
- /usr
- /bin
- /sbin
- /var
- Apps that are pre-installed with OS X
If you would like to disable SIP on your system, follow the instructions. Read more about System Integrity Protection in macOS documentation. Epiphone ft 45 cortez serial numbers.
See also:
© 2015-2020 Devart. All Rights Reserved. | Request Support | ODBC Forum | Provide Feedback |
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:
- After downloading iODBC, double-click on the downloaded .dmg file.
- Double-click on the installer file,
iODBC-SDK.pkg
, and follow the prompts.
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:
- After downloading ODBC Manager, double-click on the downloaded .dmg file.
- Double-click on the installer file,
ODBCManager.pkg
, and follow the prompts.
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 haven’t already downloaded the driver, download it now. For details, see Downloading the ODBC Driver.
- Double-click on the downloaded .dmg file,
snowflake_odbc_mac-<version>.dmg
. - Double-click on the installer file,
snowflakeODBC_<version>.pkg
, and follow the prompts.You will likely be prompted for the administrator/sudo password for the machine on which you are installing the driver.
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:
- User DSNs:
~/Library/ODBC/odbc.ini
- System DSNs:
/Library/ODBC/odbc.ini
To create a DSN, either use ODBC Manager or edit the appropriate
odbc.ini
file.Odbc Driver For Mac Excel
Creating a DSN Using ODBC Manager¶
To create a DSN in ODBC Manager:
- Manual de calculadora cientifica kenko kk 82tl. Start ODBC Manager.
- Click on User DSN or System DSN.
- Click the Add button.
- Select the driver to use (Snowflake) and click OK.
- Enter the name of the DSN and optionally a description.
- Create a Keyword/Value pair for each DSN parameter:
- Click Add to create a Keyword/Value pair.
- Isis proteus 7.7 software free download. Select Keyword and replace it with the parameter name.
- Select Value and replace it with the value for the parameter.
Repeat this process for each parameter. For details about the parameters that can be set for each DSN, see ODBC Configuration and Connection Parameters. - Click OK to create the DSN.
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.Creating a DSN by Adding an Entry in the odbc.ini
File¶
If a user or system DSN has already been created for the driver, add the new entry to the
odbc.ini
file that already exists in the corresponding directory for the type of DSN you are creating. If you are creating the first DSNfor the driver, you must manually create the odbc.ini
file and add the entry to the file.Odbc Driver Manager Missing
For each DSN, specify:
- Xmage card image download. DSN name and driver name (Snowflake), in the form of
<dsn_name>=<driver_name>
. - Directory path and name of the driver file, in the form of
Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
. - Connection parameters, such as
server
anduid
(user login name). Any connection parameters you add to the DSN do not need to be specified in the ODBC connect string. - Any additional parameters, such as default
role
,database
, andwarehouse
.
Parameters are specified in the form of
<parameter_name>=<value>
. For details about the parameters that can be set for each DSN, see ODBC Configuration and Connection Parameters.The following example illustrates an
odbc.ini
file containing two drivers, testodbc1
for account xy12345
(located in the AWS US West region) and testodbc2
for account yz23456
(located in the AWS US East region):Note the following:
- Both
testodbc1
andtestodbc2
have default roles. testodbc2
also has a default database and warehouse.
Step 3: Test the ODBC Driver¶
You can use the
iodbctest
command line utility provided with iODBC to test the DSNs you create.When prompted for the ODBC connect string, enter the required connection parameters (DSN name, server, user login name, and password), as well as any other parameters that you would like to enter as part of the connect string. Theconnect string takes parameters in the form of
<parameter_name>=<value>
, e.g. dsn=testodbc2
, with each parameter separated by a semi-colon (;
) and no blank spaces. For the list of supported parameters, seeODBC Configuration and Connection Parameters.Toshiba xario operator manual. Note
If you set the server and user login name in the DSN, the only required parameters in the connect string are the DSN name and user password.
Free Odbc Driver For Mac
For example: