Re: Connect to SQL Sererv thru Named Pipes
- From: "Andrew D. Newbould" <newsgroups@xxxxxxxxxxxxxxxxx>
- Date: Sat, 18 Jun 2005 13:49:11 +0100
In message <#O4Jmn8cFHA.2552@xxxxxxxxxxxxxxxxxxxx>, Aruna Tennakoon <aruna.tennakoon@xxxxxxxxx> writes
Hi guys,
Ijust wanted to know how to configure the SQL Server to use Named Pipes and to acced SQL Server via Named Pipes from VB 6.
Thanks for your time, -Aruna
SQL Server and MSDE both install by default with Named Pipes activated (its their default protocol). In order to use TCP/IP protocols you need to specify at install time, or use Enterprise Manager to change, or use Network Tools to change.
Any DSN, ODBC or OLEDB connection string used to connect to SQL Server will default to using named pipes unless you tell it otherwise using the "Network Library" parameter. For example:
Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;
The DBMSSOCN tell the OLEDB driver to use TCP/IP instead of the default named pipes (). Other choices for this parameter include:
Name Network library dbnmpntw - Win32 Named Pipes dbmssocn - Win32 Winsock TCP/IP dbmsspxn - Win32 SPX/IPX dbmsvinn - Win32 Banyan Vines dbmsrpcn - Win32 Multi-Protocol (Windows RPC)
There are pros and cons as normal for which protocol to use however IMO anything that is not standalone on a single PC you would be better using TCP/IP for speed, performance and flexability. Check out http://www.connectionstrings.com for more ideas on connection strings.
Kind Regards,
-- Andrew D. Newbould E-Mail: newsgroups@xxxxxxxxxxxxxxxxx
ZAD Software Systems Web : www.zadsoft.com .
- Follow-Ups:
- Re: Connect to SQL Sererv thru Named Pipes
- From: Aruna Tennakoon
- Re: Connect to SQL Sererv thru Named Pipes
- References:
- Connect to SQL Sererv thru Named Pipes
- From: Aruna Tennakoon
- Connect to SQL Sererv thru Named Pipes
- Prev by Date: Re: wordpad format incompatible
- Next by Date: Re: wordpad format incompatible
- Previous by thread: Connect to SQL Sererv thru Named Pipes
- Next by thread: Re: Connect to SQL Sererv thru Named Pipes
- Index(es):
Relevant Pages
|
