Using the ODBC Data Source Administrator

To configure Microsoft SQL Server ODBC data sources, use ODBC Data Source Administrator. You launch ODBC Data Source Administrator by clicking Data Sources (ODBC) in Control Panel.

With ODBC Data Source Administrator, you can:

• Display version information for the SQL Server ODBC driver currently installed on the system.

• Add, change, and remove data sources for the SQL Server ODBC driver.

ODBC Data Source Administrator can also create tabs for user, system, and file data sources.

User data sources are specific to the Microsoft Windows login account that is in effect when they are created. They are not visible to any other login account. They are not always visible to applications running as services on a computer.

System data sources are visible to all login accounts on a client. They are always visible to applications running as services on a computer.

File data sources were added with ODBC version 3.0. File data sources are not stored in the system registry; they are stored in a file on the client.

After you choose the type of data source, ODBC Data Source Administrator starts the SQL Server DSN Configuration Wizard, which guides you through the process of adding an ODBC data source. Select the options that you need for your data source, such as the database which contains the relevant tables.

For more information about ODBC Data Source Administrator, see your Windows documentation.