all groups > sql server (alternate) > february 2007 >
You're in the

sql server (alternate)

group:

file share


file share nick
2/25/2007 3:17:14 PM
sql server (alternate):
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.
Re: file share Erland Sommarskog
2/25/2007 11:25:01 PM
nick (cupofjava1961@aol.com) writes:
[quoted text, click to view]

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

[quoted text, click to view]

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
Re: file share Carl Tegeder
2/26/2007 4:41:06 PM
[quoted text, click to view]

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
AddThis Social Bookmark Button