Data Management

Quick Tip: Share ODBC connections between users

Learn how to make life easier for your users by making ODBC file data source names available to all users within an application.


This tip first appeared as part of TechRepublic's Windows 2000 TechMail.

Windows 2000 Professional 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 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 then 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.

What do you think of this article format?
Our editors are developing and refining new methods and formats for delivering the solutions you need. Do shorter, step-by-step pieces such as this one better help you overcome the IT problems that keep you up at night? Share your thoughts with our editors, and you could win a free TechRepublic book or CD of your choice.

Editor's Picks

Free Newsletters, In your Inbox