Server path in SQL query

Question

I have a problem with reading a file from a Windows service that is on an other computer on the network.

If I have a file locally I just give the path for example.. C:\test\

I just write C:\\Test\\ and it works great, but on the server with this address \\\Server\Test\

I don't know what to write... I would love some help!

/Nick

@DimiToulakis - As long as there is a share called C$. It all depends on the sharing setting that Nick3 has or has not set up on the remote server. — MatBailie
– MatBailie, Commented Apr 11, 2012 at 8:44

Seph · Accepted Answer · 2012-04-11 09:44:13Z

1

I think you're just looking for:

string myPath = @"\\Server\Test";

or:

string myPath = "\\\\Server\\Test";

This doesn't seem to be anything related to SQL-Server, and is just a simple C# string question.

In general you just replace \ with \\ so if there's normally two \ next to each-other in the path (such as \\server) you want to then have \\\\

answered Apr 11, 2012 at 9:44

Seph

8,72113 gold badges66 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Voislav Sauca · Accepted Answer · 2012-04-11 09:06:10Z

0

If it is a windows local machine Windows try to change the folder (x86), i have the same problem some time ago and for some reason is not working in the default folder x86., or if is a SQL server take a look at this post.

Don't forget that you need to create the file \Test in folder \\Server in order to access it.

edited Apr 11, 2012 at 9:06

answered Apr 11, 2012 at 8:52

Voislav Sauca

3,0852 gold badges21 silver badges12 bronze badges

Collectives™ on Stack Overflow

Server path in SQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related