Configure Oracle Native Driver for Windows - Configure Oracle Native Driver for Windows - To configure Oracle Native Driver for Windows, complete the following steps. - Perceptive Content - Perceptive Content Database Driver Installation and Setup Guide - Perceptive-Content/Perceptive-Content-Database-Driver-Installation-and-Setup-Guide/Foundation-26.1/Perceptive-Content-Database-Driver-Installation-and-Setup-Guide/Appendix-A-ODBC-database-driver-configuration-examples/Configure-Oracle-Native-Driver-for-Windows - Foundation 26.1 - Foundation 26.1

To configure Oracle Native Driver for Windows, complete the following steps.

1. Download the 32-bit and 64-bit instantclient basic packages.
2. Download the 32-bit and 64-bit instantclient-odbc packages.
3. Extract the instantclient and instantclient-odbc packages into the same directory, keeping the 32-bit and 64-bit packages separate.
4. Once the system extracts the odbc drivers, run the following command to install the odbc drivers.

   odbc_install.exe

5. After the system installs the drivers, you must configure the TNSNAMES file. The default location for this file is in the ORACLE_HOME/network/admin directory. If this directory does not exist, you can create it. This file should contain the service description for each datasource. The following is an example tnsnames.ora file; however, we strongly recommend you consult with your system DBA to ensure the correct configuration for your environment.

   INOWTNS =
    (DESCRIPTION =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = <HostName/IP>)
    (PORT = 1521)
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = INOW)
    )
   )

   Add the 32-bit and 64-bit Oracle native driver datasources via odbcad32. This should use the same address name specified in the tnsnames.ora file.