ODBC Drivers. Devart ODBC Drivers provide high-performance and feature-rich connectivity solutions for ODBC-based applications to access the most popular databases directly from Windows, macOS, Linux, both 32-bit and 64-bit. Drivers fully support standard ODBC API functions and data types, multiple server data types and features.
Setting up an Oracle ODBC Driver and Data Source requires more steps than the Microsoft SQL Server database setup. This article explains the steps including tnsnames.ora configuration.
Connecting to an Oracle database via and ODBC driver requires the following steps:
The following blog shows the process involved for each of these steps to get you a working connection to an Oracle database.
Prerequisites: Java JRE or SDK 6 Update 27 or later. These are required by the Oracle Universal Installer to run the ODAC installation program.
Step 1 – Install the ODAC or Oracle Client
In this example we will be installing the ODAC client to complete an ODBC setup on a Windows 7 (64-bit) operating system. You can install the full administrative option of the Oracle Client to obtain the ODBC driver.
Download the ODAC112030_x64.zip file from Oracle’s web site:
Unzip the file to a location of your choosing.
Locate the Setup.exe file under the root directory of the extracted zip file’s directories.
Double-click to run the setup program.
In the ‘Oracle Universal Installer’, click the Next button.
In the ‘Select a Product to Install’ dialog, go with the default ‘Oracle Data Access Components for Oracle Client 11.2.0.3.0’ option.
In the ‘Install Location’ dialog, enter a path to install the ODAC home directory to in the ‘Oracle Base:’ field.
In the ‘Available Product Components’ dialog, go with the default options.
In the ‘Summary’ dialog, verify that the components you have selected for install include the ‘Oracle ODBC Driver for Instant Client 11.2.0.3.0’.
Click ‘Install’.
When the installation is complete, click ‘Exit’.
This concludes the steps for installing the ODBC drivers.
Step 2 – Setup the SQLNET and TNSNAMES files
Locate the SQLNET.ora and TNSNAMES.ora in the ‘samples’ directory of the newly installed Oracle client home directory. This is typically:
C:appjohndoeproduct11.2.0client_1NetworkAdminSample
Where ‘johndoe’ is the windows user name.
Copy these two files into the ‘Admin’ directory above.
Open the ‘TNSNAMES.ora’ file in Notepad and enter your Oracle database details in the file.
Save your changes.
Windows 7 64-bit Odbc
Note: the ‘SQLNET.ora’ generally doesn’t need to be changed.
Step 3 – Create the ODBC Data Source
In the Windows Start menu, click on the Data Sources (ODBC) icon that was created by the ODAC client install.
In the ‘User DSN’ tab of the ‘ODBC Data Source Administrator’ dialog, click Add.
In the ‘Create New Data Source’ dialog, select the ‘Oracle in OraClient 11g_home1’ driver.
Click ‘Finish’.
In the ‘Oracle ODBC Driver Configuration’ dialog, enter the details of your data source.
Note: you should be able to select the TNS Service Name from the drop down list. This name will be that which you named in the TNSNAMES.ora file’s Alias = section.
Just the ones that are listed aren’t working with the A i have here This is the one gripe I have with Toshiba — their driver download page is sometimes missing a driver or two. The PCI device could be a card reader. Toshiba satellite e100 drivers for mac.
Click ‘Test Connection’ to ensure your settings are all correct.
When prompted, enter the database login credentials.
Click ‘OK’.
Click OK to complete the process.
Windows 64-bit Odbc DriversFolks who read this article also enjoyed:Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2020
Categories |