Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Read a file located on a MapDrive from SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-11-15 : 07:58:03
HP writes "I am trying to access/Read a file that is located on a Map Drive ( Local machine) using XP_getfiledetails or XP_Cmdshell while remotely Connected to another server(While I am on Remote Desktop).

When I execute XP_Getfiledetails or XP_CmdShell it is returing Error
'The system cannot find the path specified.'

My question is : How do we read/access/getdetails of a file that is located on a MapDrive from SQL Server?

Any Suggestions or Help would be greatly appreciated.

Thanks."

X002548
Not Just a Number

15586 Posts

Posted - 2004-11-15 : 09:37:21
It's got to be the mapping from the server itself...also, the sql server service account needs to have authority....



Brett

8-)
Go to Top of Page
   

- Advertisement -