Oracle ODBC Driver Setup - CADWorx - Installation & Upgrade

CADWorx Structure Installation

Language
English (United States)
Product
CADWorx
Subproduct
Structure
Search by Category
Installation & Upgrade
CAESAR II Version
13
CADWorx Version
20.2
CADWorx Structure Version
4.2

The following instructions and screen captures describe how to setup the data source name (DSN) for Oracle databases.

  1. Start the ODBC Administrator from the Control Panel to setup the Oracle ODBC Driver. Please make certain you are running the latest version of the ODBC Administrator and ODBC Drivers To check the version, go to the About Tab. The latest version of ODBC can be found on the Microsoft Web Site.

  2. Hit the Add button, and select Oracle ODBC Driver. The name "Oracle in OraDb11g_home1" may be different on your system. 

  3. In the next dialog, type in the following:

    • For CADWorx P&ID:
      Data Source Name: P&ID_ORACLE
      Service Name: CWORA11g
      The Data Source Name must be P&ID_ORACLE. The service name can be whatever you selected for the database name.

    • For CADWorx Plant:
      Data Source Name: PLANT_ORACLE
      Service Name: CWORA11g
      The Data Source Name has to be PLANT_ORACLE. The service name can be whatever you selected for the database name.

    • For CADWorx IP:
      Data Source Name: IP_ORACLE
      Service Name: CWORA11g
      The Data Source Name has to be IP_ORACLE. The service name can be whatever you selected for the database name.

  4. After the DSN is created, test the DSN by pressing the "Test Connection" button.