Article ID: 238949 - View products that this article applies to.
This article was previously published under Q238949
SQL Server allows you to choose from a number of different network libraries that you can use when connecting. You can configure these network libraries when you create a data source name (DSN) for your data source. However, an alternative way to specify the DSN is to pass in the network library, which you want to use, with the connection string. This article describes how to specify the network library that you want to use for connecting to SQL Server when connecting from a Visual Basic application that uses ActiveX Data Objects (ADO).
SQL Server allows you to use the following network libraries when establishing a connection. They are:
Note Make sure that User ID has the appropriate permissions to perform this operation on the database.
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/137635/ )INF: ODBC SQL Server Connection Parameters
(http://support.microsoft.com/kb/137634/ )INF: Reading ODBC SQL Server Driver Network Messages
Article ID: 238949 - Last Review: July 15, 2004 - Revision: 3.4
Contact us for more help
Connect with Answer Desk for expert help.