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 pasting a 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.
  6. Add the Oracle driver and add ContentaDSN data source and point to the CS/DB Server SID.
  7. Test the ODBC connection.
  8. Reboot the machine.