Microsoft KB Archive/300595

= How To Create a System Data Source Name (DSN) in Windows 95, Windows 98, or Windows NT =

Article ID: 300595

Article Last Modified on 11/1/2006

-

APPLIES TO


 * Microsoft Windows 98 Standard Edition
 * Microsoft Windows 95
 * Microsoft Windows NT Server 4.0 Standard Edition

-



This article was previously published under Q300595



IN THIS TASK
SUMMARY
 * To Create a System DSN
 * Troubleshooting



SUMMARY
A Data Source Name (DSN) is the logical name that is used by Open Database Connectivity (ODBC) to refer to the drive and other information that is required to access data. The name is use by Internet Information Services for a connection to an ODBC data source, such as a Microsoft SQL Server database. To set this name, use the ODBC tool in Control Panel.

When you use an ODBC DSN entry to store the connection string values externally, you simplify the information that is needed in the connection string. This makes changes to the data source completely transparent to the code itself.

back to the top

To Create a System DSN

 * 1) Click Start, point to Settings, click Control Panel, and then double-click 32-Bit ODBC.
 * 2) Click the System DSN tab.
 * 3) Click Add.
 * 4) Click the database driver that corresponds with the database type with which you are connecting, and then click OK.
 * 5) Type the data source name. Make sure to use a name that you will remember. You will need to use this name later.
 * 6) Click Select.
 * 7) Click the the correct database, and then click OK.
 * 8) Click OK in the next two dialog boxes.

back to the top

Troubleshooting
Make sure that you create a system DSN. ActiveX Data Objects (ADO) does not recognize user (or local) DSNs. Because they store settings in the registry, system DSNs offer slightly faster performance than file DSNs, which store connection parameters in a file on your hard disk.

back to the top

Keywords: kbhowto kbhowtomaster KB300595

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.