IMPAX 6.5.1 Application Server Knowledge Base > Configuring database connections

Creating an Oracle ODBC data source

If your IMPAX cluster has an Oracle database, configure the Application Server to communicate with the Oracle database that contains the patient information.

Note:

Note:

You must have the Oracle 10g Client installed before configuring the connection. For installation instructions, refer to "" in the IMPAX 6.5.1 Application Server Installation, Upgrade, and Configuration Guide.

To create an Oracle ODBC data source

  1. Open the Windows Administrative Tools.

  2. Double-click Data Sources (ODBC).

  3. Switch to the System DSN tab.

  4. Click Add.

  5. In the Create New Data Source dialog, select Oracle in ohome.

  6. Click Finish.

  7. As the Data Source Name, type mvf_ora.

  8. Type a description, if needed.

  9. As the TNS Service Name, type

    MVF.world

  10. As the User ID, type

    mvf

    The user ID must be lowercase.

  11. Click Test Connection.

  12. In the Oracle ODBC Driver Connect dialog, type the Service Name MVF.world, User Name mvf, and Password mvf.

  13. Click OK.

  14. The message Connection to Oracle database successful appears. Click OK.

    If the test fails, verify that the information is correct and test the connection again.

  15. To save the changes and close the dialog, click OK.

  16. To save the new source and exit the ODBC Data Source Administrator dialog, click OK.

    The Oracle ODBC data source has been created.

  17. Repeat steps 7—16. In step 7, as the Data Source Name, type

    mvf


To complete the connection, perform this procedure: Connecting the Business Services to an Oracle database.


Topic number: 59290

Applies to: IMPAX 6.5.1 Application Server Knowledge Base