Dsn Oracle Odbc Drivers For Mac

17-09-2021 by

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:

Oracle
  • 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)

You have to add the Database tns entries in the tnsnames.ora file in the same linux serer with name ASPD that you have used for your ODBC dsn name above.

Connection String Oracle Odbc Dsn

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)

The Dremio ODBC Mac driver allows Mac-based applications to work with Dremio. The following information installs the driver and creates a default system DSN. Navigate to the Dremio ODBC Mac driver download site. Click on Download for MacOS. Navigate to driver download location (usually the Downloads folder). The ODBC drivers need to specify which encoding to use with the ODBC Driver Manager. By default, the CData ODBC Drivers for Mac are configured to use UTF-32 which is compatible with iODBC, but other Driver Managers may require alternative encoding. 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. OpenLink ODBC Driver for Oracle 7.0 for Mac is free to download from our software library. The size of the latest installation package available is 12 MB. Our built-in antivirus checked this Mac download and rated it as 100% safe. The application lies within Business Tools, more precisely General.

Dsn oracle odbc drivers for mac osMicrosoft odbc for oracle dsn
  • Free BSD
    • FreeBSD 11.0 (64Bit)
    • FreeBSD 10.3 (64Bit)

Oracle Odbc Drivers Windows 7

Download and Install the ODBC Driver

Dsn oracle odbc
  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

IssueReasonSolution
Config_odbc does not startSome 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.

How To From Netflix On Mac
Subprocess Post Installation Script Cydia

Comments are closed.