Configuring ODBC Connections for SQL

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.

  1. Click Control Panel > Administrative Tools > Data Sources (ODBC).
  2. On the System DSN tab, click Add.

    The Create New Data Source dialog is displayed.

  3. Select SQL Server and click Finish.

    The Create a New Data Source to SQL Server dialog is displayed.

  4. In the Name and Description fields, type an appropriate name and description for the data source, for example, mmsdata1.
  5. From the Server list, select (local) or the appropriate server name. Click Next.
  6. Click the With Windows NT authentication using the network login ID option, and then click Next.
  7. Click the Change the default database to option and select the corresponding database name from the list, for example, mmsdata1, and then,click Next.
  8. Click Finish.

    The ODBC Microsoft SQL Server Setup dialog is displayed.

  9. To ensure that the connection is working, click Test Data Source.

    • If the test fails, go back and check the settings.

    • If the test is successful, click OK. You are returned to the ODBC Data Source Administrator.

  10. Click OK.