ODBC Alias tab

On this window, you can create aliases for ODBC connection strings that are hard-coded in the 997 map (997 maps use 997 as the DSN, which is written to the .map file when the map is generated), allowing you to change the files dynamically at runtime. (This is the –ad switch explained in ECRTP Reference Guide. This switch allows you to adapt maps between machines and platforms.)

StepsCreating an ODBC alias

  1. Select Add

    The runmap window displays.

  2. Enter the DSN that you want to replace at runtime and select OK.

    The DSN is automatically entered under ODBC Connection Strings inside Map.

  3. Select the right arrow.

    The runmap window displays.

  4. Enter the DSN that you want to use at runtime and select OK.

    The DSN is automatically entered under ODBC Connection Strings during Run Time.

You have now created an alias for the original Driver Connect String. When the program encounters the original DSN, it uses the new alias DSN in its place.

StepsDeleting an ODBC alias

  1. To remove a pair of DSNs on one line, highlight the line and select Delete.

StepsEditing an ODBC Alias

  1. Highlight the DSN you want to edit and select Edit.

    The ODBC Alias window displays.

  2. On this window, you can change the name of the DSN.