PRB: Configuring DSNs with SQL Server Net-Libraries (289573)
The information in this article applies to:
- Microsoft ODBC Driver for SQL Server 2000.80.194
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 7.0
- Microsoft Data Access Components 2.6
This article was previously published under Q289573 SYMPTOMS
When you create or configure ODBC data source names (DSNs) using the Microsoft SQL Server ODBC driver, issues such as the following may occur:
- Switching of Net-Library protocols.
- A new DSN's protocol is used for older DSNs, or vice versa.
CAUSE
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.
RESOLUTION
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.
WORKAROUND- In the Client configuration utilities for SQL Server, create an alias using a different name than the server name.
- Create or modify a DSN, and for the server name, choose the alias (not the server) from step 1.
- Save the DSN and reopen.
Note that this time the network library persists.
REFERENCES
For more information, see "Net-Libraries and Network Protocols" at the following Microsoft Developer Network (MSDN) Web site:
For additional information, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
257434 INF: The Protocol in Existing DSN Is Replaced by the Protocol in New DSN to the Same SQL Server Name
260249 PRB: DSN Network Library Shown as "Other" in ODBC Administrator
Modification Type: | Major | Last Reviewed: | 8/25/2006 |
---|
Keywords: | kbinfo kbprb KB289573 |
---|
|