Database & Application Miscellaneous: xp_write_file restrictions ?

• geoffatdatagaard / 212 / Mon, 16 Nov 2009 01:20:00 GMT / 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:

  xp_write_file, restrictions, database, application

• http://database.itags.org/database-application/157953/«« Last Thread - Next Thread »»

• 1. 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 |

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