file share

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.nick (cupofjava1961@.aol.com) writes:

Quote:

Originally Posted by

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.)

Quote:

Originally Posted by

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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 25, 6:25 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

nick (cupofjava1...@.aol.com) writes:

Quote:

Originally Posted by

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.)
>

Quote:

Originally Posted by

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, esq...@.sommarskog.se
>
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