#ORACLE INSTANT CLIENT ODBC MANAGER MAC HOW TO#
#ORACLE INSTANT CLIENT ODBC MANAGER MAC MAC OS X#
#ORACLE INSTANT CLIENT ODBC MANAGER MAC INSTALL#
#ORACLE INSTANT CLIENT ODBC MANAGER MAC DRIVER#

The MSI installation process will even take care of registering MariaDB Connector/ODBC with the ODBC Driver Manager, so that it is ready to use immediately. MariaDB Connector/ODBC supports the built-in ODBC Driver Manager on Windows, so nothing else needs to be installed. The MSI installation process is fairly straightforward.

#ORACLE INSTANT CLIENT ODBC MANAGER MAC INSTALL#

To install MariaDB Connector/ODBC on Windows, we distribute MSI packages. Installing MariaDB Connector/ODBC on Windows

#ORACLE INSTANT CLIENT ODBC MANAGER MAC HOW TO#

See the instructions below for information on how to install the MariaDB Connector/ODBC package for your operating system. MariaDB Connector/ODBC packages can also be downloaded by selecting ODBC connector as the Product on the following page: MariaDB Connector/ODBC packages can be downloaded by selecting your desired version from the following page:

TLS-Related Connection Parameters Examples.

Installing Client Authentication Plugins.

Creating a Data Source with MariaDB Connector/ODBC.

Installing MariaDB Connector/ODBC from Source.

#ORACLE INSTANT CLIENT ODBC MANAGER MAC MAC OS X#

Installing MariaDB Connector/ODBC on Mac OS X.

Installing MariaDB Connector/ODBC on Debian/Ubuntu.

Installing MariaDB Connector/ODBC on RHEL/CentOS.

Installing MariaDB Connector/ODBC on Linux.

Installing MariaDB Connector/ODBC on Windows.

SelectCompare can be used to fetch data from multiple data sources, as long as there is an OLEDB or ODBC driver available for them. One of the most important database technologies on the market is undoubtedly Oracle and SelectCompare can use Oracle as a data source without any problems. This post outlines the process of installation and configuration of the Oracle ODBC driver, setup of the ODBC data source, and configuration of a connection in SelectCompare. Select the Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit) If you wonder how SelectCompare might be used with Oracle, have a look at the second use case from this post.ĭownload and install the Oracle ODBC driverįor this post, I chose the 32-bit InstantClient implementation of the driver. When the package is downloaded, run the setup.exe. An installation wizard will appear, guiding you through the process of installation. On the first screen, select the InstantClient option and click Next.įollow the installation process using default settings. If everything went fine, you should see the confirmation of the successful installation of the driver on your workstation.įirst, we will start with the setup of the ODBC data source in the ODBC Data Source Manager. Note that you need to have your TNSNAMES.ORA file in working order. Open ODBC Data Source Administrator (32-bit) and click the 'Add' button. Select the appropriate driver from the list that will appear. Click 'Test Connection'Įnter the user password when prompted and click OK: Click the 'Finish' button.Įnter the name of the data source, any description you might find useful, the TNS service name, and the username. When everything is set up correctly, you should see a confirmation of the successful connection. Click OK.Ĭlick OK on the Oracle ODBC Driver Configuration screen. Click OK - you are ready to use the data source in SelectCompare! You should see the newly created data source on the main screen of the ODBC Data Source Administrator. Set up Oracle connection in SelectCompareįinally, you are ready to set up a connection in SelectCompare.

Open SelectCompare and switch to the Connections screen.Ĭlick the 'Create new connection' button:Įnter the name of the connection and choose its color. Select “ Microsoft ODBC Data Source” and select the provider displayed on the screenshot. Select the ODBC connection that you created in the ODBC connection manager.Įnter username and password and click Test Connection.Ĭlick OK on the connection properties dialog.

Use connection in your comparison project You can also test the connection in SelectCompare:Įnsure that you save the connection before you exit the screen. Now you are ready to use the defined connection in your project.Ĭreate a new or open an existing project in SelectCompare. Enter the name of the project and select a color you like.

Oracle instant client odbc manager mac