file share

[nick]

Can someone please tell me what is meant by a file share?

I'm doing a little reading on MS Sql Server and they talk about how
you can connect to the sql server through a named pipe.
I'm guessing that a file share means a specific service running on a
server. Is this correct?
The book says the following:
When you connect to a file share you use a Universal Naming Convention
path to a file server: \\FILESERVER\Sharename.

To connect to a named pipe, you connect to a share of the form:
\\COMPUTER\pipe\sql\query

Thanks Hope you can clear this up for me.

[Erland Sommarskog]

nick (cu***********@aol.com) writes:

Can someone please tell me what is meant by a file share?

A file share is a directory to which access have been opened to users
on other machines. You can set up a file share on your machine, by right-
clicking a directory in Explorer and select Sharing and Security. (In
Windows XP.)

The book says the following:
When you connect to a file share you use a Universal Naming Convention
path to a file server: \\FILESERVER\Sharename.

Yes, this the syntax to refer to a disk on a different computer, although
it is also possible to map a drive letter to a remote disk.

All this has very little to do with SQL Server, but is common knowledge
about Windows.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Carl Tegeder]

On Feb 25, 6:25 pm, Erland Sommarskog <[e-mail]:

nick ([e-mail]) writes:

Can someone please tell me what is meant by a file share?

A file share is a directory to which access have been opened to users
on other machines. You can set up a file share on your machine, by right-
clicking a directory in Explorer and select Sharing and Security. (In
Windows XP.)

The book says the following:
When you connect to a file share you use a Universal Naming Convention
path to a file server: \\FILESERVER\Sharename.

Yes, this the syntax to refer to a disk on a different computer, although
it is also possible to map a drive letter to a remote disk.

All this has very little to do with SQL Server, but is common knowledge
about Windows.

--
Erland Sommarskog, SQL Server MVP, [e-mail]

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

No Erland,

This is completely the wrong answer. Some people should not attempt to
answer questions that they have absolutely no answer for. At any rate,
a shared pipe has more to do with a Unix client/odbc connection to a
MS-SQL server using Unix socket/lock files. Anyone who really needs to
know the answer to this can take a look at http://en.wikipedia.org/wiki/Unix_file_types
.... perhaps this will give some of you something to look at.

HTH,

Carl Tegeder
MS-SQL MVP
Advanced Master MS-SQL Administrator