Dsn Oracle Odbc Drivers For Mac

• Dsn Oracle Odbc Drivers For Mac Os
• Microsoft Odbc For Oracle Dsn
• Dsn Oracle Odbc Drivers For Mac 64-bit

Driver name to identify the Oracle ODBC driver residing in current Oracle Instant Client home. The default name will be like 'Oracle 19c ODBC driver' DSN. Sets ODBC DSN name. The default name will be 'OracleODBC-19c' ODBCINI. Directory path of the.odbc.ini file. The default path is the user's home directory, for example /.odbc.ini. The ODBC drivers on Linux and macOS iterate sequentially through all IP addresses associated with a DNS hostname if you are not connecting to an availability group listener, and multiple IP addresses are associated with the hostname. The Oracle ODBC driver for Oracle Database enables ODBC applications to connect to Oracle Database. In addition to standard ODBC functions, users can leverage Oracle specific features for high performance data access. Install the unixODBC Driver Manager Download unixODBC from ftp.unixodbc.org/pub/unixODBC.

Dsn Oracle Odbc Drivers For Mac Os

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:

1. After downloading iODBC, double-click on the downloaded .dmg file.

2. 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:

1. After downloading ODBC Manager, double-click on the downloaded .dmg file.

2. Double-click on the installer file, ODBCManager.pkg, and follow the prompts. Adobe reader for mac os x.

The installer installs ODBC Manager in the ~/Applications/Utilities directory.

Step 1: Install the ODBC Driver¶

To install the Snowflake ODBC driver for macOS:

1. If you haven’t already downloaded the driver, download it now. For details, see Downloading the ODBC Driver.

2. Double-click on the downloaded .dmg file, snowflake_odbc_mac-<version>.dmg.

3. 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.

Creating a DSN Using ODBC Manager¶

To create a DSN in ODBC Manager:

1. Start ODBC Manager.

2. Click on User DSN or System DSN.

3. Click the Add button.

4. Select the driver to use (Snowflake) and click OK.

5. Enter the name of the DSN and optionally a description.

6. Create a Keyword/Value pair for each DSN parameter:

   1. Click Add to create a Keyword/Value pair.

   2. Select Keyword and replace it with the parameter name.

   3. 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.

7. 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.

For each DSN, specify:

• 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 and uid (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, and warehouse.

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 and testodbc2 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.

Microsoft Odbc For Oracle Dsn

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.

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.

For example:

Dsn Oracle Odbc Drivers For Mac 64-bit

The Exasol ODBC driver for Linux/Unix is designed to run on as many distributions as possible. However, it is tested on the following systems:

• Linux
  • Red Hat / CentOS 7 (x64)
  • Red Hat / CentOS 6 (x86/x64)
  • Debian 8 (x86/x64)
  • Ubuntu 16.04 LTS (x86/64)
  • Ubuntu 14.04 LTS (x86/64)
  • SUSE Linux Enterprise Server 12 (x64)
  • SUSE Linux Enterprise Desktop 12 (x64)
  • SUSE Linux Enterprise Server 11 (x86/x64)
  • openSUSE Leap 42.2 (x64)
• macOS
  • macOS El Capitan (10.11)
  • macOS Sierra (10.12)
  • macOS Mojave (10.14)
  • macOS Catalina (10.15)

The ODBC driver works on Mac OS X with the driver manager iODBC in two variations (depending on the application):

• As system library (included in the system)
• As framework in version 3.52.7 (for more information, see www.iodbc.org)

• Free BSD
  • FreeBSD 11.0 (64Bit)
  • FreeBSD 10.3 (64Bit)

Download and Install the ODBC Driver

1. Go to the Exasol Downloads page and from Download ODBC Driver section, download the ODBC Driver according to your OS (Unix, Linux, or macOS). For example, for Linux, select EXASOL_ODBC-<version>.tar.gz.
2. Run the following commands to extract the package in a directory:
   • For Linux/macOS: tar -xzf EXASOL_ODBC- <version>.tar.gz
   • For Solaris: gtar -xzf EXASOL_ODBC-<version>.tar.gz

For configuration information, check the readme.txt file included in the driver package.

Configure ODBC Driver and Data Sources

To configure the driver, run the config_odbc program to generate the odbc.ini file. Change into the install directory and then run config_odbc as shown below:

Running the config_odbc performs the following operations:

• Scans the system for available ODBC driver manager
• Check for missing (3rd party) packages
• Creates an odbc.ini config file
• Creates a wrapper script to start applications
• Tests the database connectivity
• Suggests the correct DSN an application needs based on the driver manager it uses

The generated odbc.ini file contains DSN entries for all supported ODBC driver managers. To further configure the options in the odbc.ini file, see Connecting through Connection Strings.

The config_odbc program also allows non-interactive use. For details, run the following command:

Known Issues

Issue	Reason	Solution
Config_odbc does not start	Some operating system make not have the full Perl installation.	Install a full Perl system and try again. Fix: minimal Debian apt-get install perl Fix: minimal CentOS 7 yum install perl-Digest-MD5
Error 'Data source name not found, and no default driver specified'	Wrong version of the unixODBC is used because of multiple installation instances. The unixODBC driver manager is using the wrong odbc.ini file.	Specify the correct version of the unixODBC through isql-version. Specify the correct odbc.ini file through the environment variable ODBCINI.
Error 'Invalid UTF-8 character in input'	Wrong locale defined in the LC_ALL variable.	Define a locale in the LC_ALL variable that can display the characters properly.
Missing or wrong characters in output of console or your ODBC application	Incompatible locale defined in the odbc.ini file.	Set the environment variables LC_CTYPE and LC_NUMERIC or the parameters CONNECTIONLCCTYPE and CONNECTIONLCNUMERIC in the odbc.ini file to a locale that can display the characters. Applications using the DataDirect driver manager need UTF-8 locales.