Data Transformation Engine ODBC Adapter Reference Guide

ODBC Adapter Reference Guide

Chapter 7 - Configuring DSN for Event

Server Startup

Note This information also applies to establishing a Windows-based data source name

for the Informix adapter. For information about how to configure a DSN for Unix,

refer to your Unix documentation.

Using ODBC, data sources are configured in the ODBC Data Source

Administrator applet in the Control Panel as system sources (System DSN)

that are visible to all users and NT services on the system, or to user sources

(User DSN) that are visible only to you (the current user).

Note For Windows 2000, access this (ODBC Data Source Administrator) applet by

selecting Administrative Tools in the Control Panel, then Data Sources

(ODBC).

Based upon each data source configuration, the data source is allowed access only

if the logon account is correctly specified. A system data source can be accessed

only when using a system account logon, which is the default. A user data source

can be accessed only when using a user account logon that must be specified.

When using the NT Event Server and access to ODBC data sources is required, the

Event Server must be started from the Services applet with the correct logon

(either system or user account) that allows access to the data sources required by

the Event Server during run-time. For more information about this and using the

Windows 2000 machine, refer to the Event Server Reference Guide.

For example, if a data source is defined as a system source in the System Data

Sources list on the System DSN tab, the Event Server must be started using the

System Account logon, which is the default.