Using the ODBC Data Source Administrator

To configure Microsoft® SQL Server™ ODBC data sources, use the ODBC Data Source Administrator. For more information, see Miscellaneous Utilities.

Using the 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.

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

User data sources are specific to the Microsoft Windows NT® 4.0, Windows® 2000, Windows 95, or Windows 98 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 a service on a computer running Windows NT 4.0 or Windows 2000.

System data sources are visible to all login accounts on a client. They are always visible to applications running as a service on a computer running Windows NT 4.0 or Windows 2000.

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, the ODBC Data Source Administrator starts the SQL Server DSN Configuration Wizard, which guides you through the process of adding an ODBC data source.

To check the ODBC SQL Server driver version