Defining map DSN settings

Use the Map DSN tab when the trading partner and/or the log information are stored in databases that are accessed through ODBC. On this tab, enter the information that tells the program how to access the databases.

NoteIf you also use EC Gateway Server, you must use a different DSN for the trading partner and the log, even if they both point to the same database. Otherwise, you may experience problems with some of your Gateway reports.

StepsDefining DSN settings

Perform these steps for both the trading partner DSN and the log DSN

  1. Select the Data Source Name text box up arrow

    The Data Source Name window displays.

  2. Double-click on a DSN to select it.

    The DSN is entered in the Data Source Name text box and the driver connect string is automatically created.

    If you have not created the DSN, select Configure Data Source to open the the ODBC configuration window. Once you have created your DSNs, proceed with the procedure.

    NoteFor certain databases, such as MS SQL Server and Oracle, you may need to manually edit the string in the text box to add a user ID and password.

  3. Select Test Trade Partner Connection or Test Log File Connection to test the connections.

    If you select Clear TP Fields, the program removes all of the information entered in the text boxes on the Trade Partner section of this tab. If you select Clear Log Fields, the program removes all of the information entered in the text boxes on the Log section of this tab.

  4. Select OK. You return to the Project/Map window.