Posted by Carl Tegeder on 02/27/07 00:41

On Feb 25, 6:25 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> nick (cupofjava1...@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, 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

[Back to original message]