Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    7

    Red face Unanswered: ActiveX script cant recognise mapped drive/UNC path

    hi all,
    pls help.

    i have an activex script inside a dts package that read a mapped drive. that dts runs fine when executed interactively but failed when run via SQL job. the server is on windows NT and using MS SQL 2000.

    what the activex script does actually read a mapped drive on unix server. i suspect SQL job cant read mapped drive. so i changed to UNC path using syntax \\servername\sharefoldername\filename.txt but the job still failed.

    is SQL job running on win NT recogised UNIX mapped drive by the way? appreciate urgent help! big thanks!

    -hameiza

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Is the current windows user the same in both cases? (maybe a permissions issue?)
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Nov 2007
    Posts
    7
    hi,
    when logon to the server, i am log on as Administrator. if i run the dts individually, it runs ok even with mapped drive/UNC path-means can find the location of the file. but i am not sure under what id the server is using if the dts is run thru SQL job? (related to permission issue).

    the owner of the job is sa. when called the dts thru job step, i also use sa username.

    anymore helpful hints?
    thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •