Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
HOW TO: Create a System Data Source Name in Windows XP
Article ID: 305599 - View products that this article applies to.
This article was previously published under Q305599
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 used by Internet Information Services (IIS) 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 externally store the connection string values, simplify the information that is needed in the connection string. When you do this, changes are made to the data source that are completely transparent to the code. This article describes how to create a system data source name in Windows XP.