Home » Category » Database & Application Miscellaneous

Database & Application Miscellaneous: xp_write_file restrictions ?

212| Fri, 23 May 2008 14:28:00 GMT| geoffatdatagaard| Comments (2)
Sybase 9.0.2.3137 running as Network Server (Service) on XPP or W2K.

Can anybody confirm for me that xp_write_file is restricted to ONLY writing
files to the Servers local disks.

There is nothing (I can find) in the docs but I cant get it to work on
anything other than disks local to ASA Server host machine.
Even mapped drives fail.

My findings (Done from ISQL)

select xp_write_file('c:One.txt','1234567890')
=> works fine
select xp_write_file('z:One.txt','1234567890')
=> fails every time even though Z: is defined on server host.
select xp_write_file('\\\\MyServer\\SharedDocs\
\One.txt','1234567890') =>
fails every time.

TIA

Keywords & Tags: xp_write_file, restrictions, database, application

URL: http://database.itags.org/database-application/157953/
 
«« Prev - Next »» 2 helpful answers below.
GeoffAtDatagaard wrote:

> Sybase 9.0.2.3137 running as Network Server (Service) on XPP or W2K.
> Can anybody confirm for me that xp_write_file is restricted to ONLY writin
g
> files to the Servers local disks.

It is restricted to whatever is accessible to the account the server
runs under. By default, it is the LocalSystem account that doesn't have
access to anything "foreign".

Dmitri.

dmitri | Fri, 23 May 2008 14:29:00 GMT |

Thanks Dmitri, problem solved !

"Dmitri" <NOdimSPAM...mail15.com> wrote in message
news:44191df2$1...forums-1-dub...
> GeoffAtDatagaard wrote:
>
writing[vbcol=seagreen]
> It is restricted to whatever is accessible to the account the server
> runs under. By default, it is the LocalSystem account that doesn't have
> access to anything "foreign".
> Dmitri.

geoffatdatagaard | Fri, 23 May 2008 14:30:00 GMT |

Database & Application Miscellaneous Hot Answers

Database & Application Miscellaneous New questions

Database & Application Miscellaneous Related Categories