Configuring ODBC Connections for Oracle

Each database must communicate with the Trapeze software using an ODBC (Open DataBase Connectivity) connection. ODBC is a standard application programming interface for connecting to different databases using a common language. Trapeze6 supports Microsoft SQL and Oracle databases.

To launch the ODBC Data Source Administrator from Windows, in the system folder, Control Panel > Administrative Tools > Data Sources (ODBC) For easy access, create a shortcut to the ODBC executable file.

  1. Launch the ODBC Data Source Administrator.
  2. On the System DSN tab, click Add.
    The Create New Data Source dialog box is displayed.
  3. Choose Microsoft ODBC for Oracle from the list.
  4. Click Finish.

    The Microsoft ODBC for Oracle Setup dialog box is displayed.

  5. In the Name and Description fields, type an appropriate name and description for the data source, and then type the Oracle SID of the database.
  6. Click OK.
  7. In the ODBC Data Source Administrator dialog box, click OK to complete the connection.

    For more information on the ODBC, please refer to the appropriate vendor documentation.