>I am creating a VFP COM object which is having some difficulty. I am doing a SET PATH to my data directory. If the SET PATH is to one of my local drives (like: D:\mysys\data), it works fine. However, if I made a drive to my D: drive, and do a SET PATH to P:\mysys\data, it says, 'file not found'.
>
>If I specified the file like this: use P:\mysys\data\mytable.dbf, I get 'file access is denied'.
>
>I am using this COM object in ASP, and it appears to only happen there. If I do any of these techniques in VFP, they all work. I have also tried use \\MyMachine\mysys\data (no drive mapping, only sharing).
>
>I assume this is a permissions problem, but I have tried setting permission everywhere (in IIS, in DCOMCNFG, in Sharing, etc.). Any help would be greatly appreciated!
The problem is likely that the userid in effect when the ASP page is executing doesn't have the necessary access; the userid would be either IUSR_anonymous or IUSR_MACHINENAME (eg if the name of the server is MYSERVER, IUSR_MYSERVER) and that account needs permissions. I'd stringly advise that you pick up a copy of Rick Strahl's
Internet Applications with Visual FoxPro 6.0 which goes into considerable detail about this and other related issues.