Documentation Center

Configuring the Oracle ODBC Data Source 64-bit

If installing on a 64‐bit Administration client and using an Oracle database for Contenta data, before installing the Contenta software, configure the Oracle ODBC Data Source.

About this task

Procedure

  1. Make sure that the Firewall is turned off or that the Oracle port is open.
  2. Create a shortcut to “C:\Windows\SysWow64\odbcad32.exe” under Control Panel > Administrative Tools by copying the file odbcad32.exe and doing a paste shortcut under Control Panel > Administrative Tools.
  3. Rename the shortcut to “32_Bit_Data_Source (ODBC)”.
  4. Add the Contenta SID to the tnsnames.ora file.
  5. Execute “ODBC Data Source (32‐bit)” under Control Panel > Administrative Tools, double‐click on the entry in the list, which displays the ODBC interface.
  6. Add the Oracle driver and add ContentaDSN data source and point to the CS/DB Server SID.
  7. Test the ODBC connection.