WINDOWS 2000 PROFESSIONAL

SHARE ODBC CONNECTIONS BETWEEN USERS

Windows 2000 supports Open Database Connectivity (ODBC), a standard mechanism developed by Microsoft to enable clients to access databases created by various database management systems without installing the DBMS on the client locally.

For example, you might create an ODBC connection on a server to enable access to a product database from the Web. The Web pages, hosted by IIS, include the calls necessary to access the ODBC connection and the underlying data.

Windows 2000 supports three kinds of ODBC data source names (DSNs): system, user, and file. Windows 2000 stores system and user DSNs in the registry. It stores file DSNs, however, as files with a .dsn file extension.

A common use for a file DSN is to provide a data connection for a local application, such as Excel or Access. The advantage of using a file DSN is that you can share it easily with users, either by placing it on a network share or by copying the DSN file to each user's computer.

To share file DSNs with users, use the Data Sources applet in the Administrative Tools applet of Control Panel to first create the DSN, and place the DSN in a location accessible to users. Users must add the DSN folder path to their respective application settings.

For example, if users are working in Excel, choose Data | Import External Data | New Database Query. In the Choose Data Source dialog box, click Options, enter the path to the shared DSN folder, and click OK to close both dialog boxes. The DSNs will then be available to other users within the application.