Article ID: 289573 - View products that this article applies to.
This article was previously published under Q289573
When you create or configure ODBC data source names (DSNs) using the Microsoft SQL Server ODBC driver, issues such as the following may occur:
If you use the server name (for example, the SQL Server instance name) for creating multiple DSNs, modifying the network protocol for any one of them will affect all the DSNs that are using this name.
Also, from Microsoft Data Access Components (MDAC) 2.6 and later, the default network library is TCP/IP. If you use a server name (in other words, you do not create a server alias), even if you configure your DSN to use named pipes, it will revert back to TCP/IP. To resolve this problem, follow the steps given in the "Workaround" section.
Create and use server aliases with the required Net-Library settings using the ODBC Administrator or the SQL Server Client Network Utility, Cliconfg.exe. See the "More Information" section for details.
When you specify or select the server name in the Server select box in the Microsoft SQL Server DSN Configuration dialog box from the ODBC Administrator during DSN creation, it creates a server alias with the specified name. This is actually a server alias name rather than the server name itself. If multiple DSNs use the same name, they all use the latest protocol settings of that server alias.
The configuration information of the server aliases is stored in the registry under the following key:
ODBC AdministratorTo add a server alias using the ODBC Administrator, follow these steps:
Client Network UtilityThe Client Network Utility, Cliconfg.exe, ships with several products, including Microsoft SQL Server and Microsoft Data Access Components (MDAC) version 2.1 SP2 and later.
This utility is typically placed in the C:\WINNT\SYSTEM32 folder on Microsoft Windows 2000 and Microsoft Windows NT systems and in the C:\WINDOWS\SYSTEM folder on Microsoft Windows 9x systems.
To start this utility, follow these steps:
For more information, see "Net-Libraries and Network Protocols" at the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/aa213773(SQL.80).aspxFor additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/257434/EN-US/ )INF: The Protocol in Existing DSN Is Replaced by the Protocol in New DSN to the Same SQL Server Name
(http://support.microsoft.com/kb/260249/EN-US/ )PRB: DSN Network Library Shown as "Other" in ODBC Administrator
Article ID: 289573 - Last Review: March 27, 2007 - Revision: 5.3
Contact us for more help
Connect with Answer Desk for expert help.