Oracle Instant Client 10G 64 Bit Download
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: • Install the ODAC (Oracle Data Access Components) or Oracle Client on the Workstation or Application Server. • Setup the SQLNET and TNSNAMES files in the Client or ODAC home’s Admin directory. • Use the ODBC Data Source configuration tools to create the ODBC Data Source. 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.
Oracle Database 10g Client 64 Bit Download
Oracle Instant Client 10g 64 Bit Download
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.