|
Home > Archive > MS SQL Server > March 2006 > What is named pipe?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What is named pipe?
|
|
|
| When I use Sql, I can choose between named pipe and TCP/IP.
I never heard about named pipe before, what is it?
| |
| Mike Hodgson 2006-03-30, 8:23 pm |
| It's a network protocol (as is TCP). Microsoft have written a few
net-libraries for SQL clients to communicate with SQL servers and those
net-libraries are targeted as specific network protocols; there's one
for TCP sockets, one for named pipes, one for shared memory, etc.
This is documented in BOL:
Client Net-Libraries and Network Protocols
<http://msdn.microsoft.com/library/d...client_8uwj.asp>
Named Pipes vs. TCP/IP Sockets
<http://msdn.microsoft.com/library/d...tun_1a_7fcj.asp>
--
*mike hodgson*
http://sqlnerd.blogspot.com
ad wrote:
>When I use Sql, I can choose between named pipe and TCP/IP.
>
>I never heard about named pipe before, what is it?
>
>
>
>
| |
| Hal Berenson 2006-03-31, 3:23 am |
| Named Pipes is a egacy Windows interprocess communications abstraction that
allows transparency over various underlying communications mechanisms. It
was the original mechanism that SQL Server used for local interprocess
communications, however now SQL Server uses a shared memory netlib instead.
And TCP/IP has become almost universal as the client/server protocol.
Basically, you don't want to use Named Pipes unless you have a legacy
situation where you need to enable communications with an existing client or
server that is using Named Pipes and can't be changed to use something else.
--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"ad" <flying@wfes.tcc.edu.tw> wrote in message
news:Ow6QgWDVGHA.1728@TK2MSFTNGP11.phx.gbl...
> When I use Sql, I can choose between named pipe and TCP/IP.
>
> I never heard about named pipe before, what is it?
>
|
|
|
|
|