To configure an ODBC data source, click Tools --> ODBC Data Source Administrator. After you select the driver for your data source, the configuration options and steps are driver specific. If your configuration requires you to specify an authentication method for the data source, be sure that you specify the same method used by the database server.
You must configure your ODBC data sources as either system data sources (system DSNs) or user data sources (user DSNs). A system data source is defined for the computer and accessible to all users that log on to that computer. A user data source is defined only for a particular user on the computer.
ODBC data sources typically require the following types of information:
Additionally, for some data sources, you can select advanced options on data source configuration pages.
After you have configured one ODBC data source for a particular database server, you can autoconfigure additional data sources for other databases on that server, as described in the following section.