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
Note: You must configure the ODBC with 32-bit Odbcad32.exe (Data Source Administrator tool) on a 64-bit machine.
Procedure
- Make sure that the Firewall is turned off or that the Oracle port is open.
- Create a shortcut to C:\Windows\SysWow64\odbcad32.exe under by copying the file odbcad32.exe and pasting a shortcut under .
- Rename the shortcut to 32_Bit_Data_Source (ODBC).
- Add the Contenta SID to the tnsnames.ora file.
Note: On the Contenta Server, ensure that Contenta SID is added to tnsnames.ora file under 32-bit Oracle.
- Execute ODBC Data Source (32-bit) under .
- Add the Oracle driver and add ContentaDSN data source and point to the CS/DB Server SID.
- Test the ODBC connection.
- Reboot the machine.