MDAC 2.5 SDK - ODBC Data Source Administrator
After you have installed an ODBC driver from the driver's setup program, you can define one or more data sources for it. The data source name (DSN) should provide a unique description of the data; for example, Payroll or Accounts Payable. The user and system data sources that are defined for all currently installed drivers are listed in the User DSN or System DSN tabs of the ODBC Data Source Administrator dialog box. The file data sources in a given directory are listed in the File DSN tab; the directory to be shown is entered in the Look in box in the File DSN tab.
A data source associates a particular ODBC driver with the data you want to access through that driver. For example, you might create a data source to use the ODBC dBASE driver to access one or more dBASE files found in a specific directory on your hard disk or a network drive. Using the ODBC Data Source Administrator, you can add, modify, and delete data sources, as described in the following table.
| Action | Description |
| Adding data sources | It is possible to add multiple data sources, each one associating a driver with some data you want to access by using that driver. Give each data source a name that uniquely identifies that data source. For example, if you create a data source for a set of dBASE files that contain customer information, you might name the data source "Customers." Applications typically display data source names for users to choose from.
Adding a file data source is slightly different from adding user or system data sources. For more information, see the ODBC Data Source Administrator help file. |
| Modifying data sources | Depending on your requirements, you might find it necessary to reconfigure data sources. You can reset options by clicking Configure in any driver setup dialog box. |
| Deleting data sources | Click Remove after selecting a data source. |
Note Data sources for 32-bit drivers can be used by both 16-bit and 32-bit applications. The Driver Manager provides thunking layers to allow 16-bit applications to use 32-bit drivers.
For more information about file data sources, see Connecting Using File Data Sources in Chapter 6, "Connecting to a Data Source or Driver," or the SQLDriverConnect function reference in the ODBC Programmer's Reference.