COM objects run under the IUSR_ account which doesn't have access to those resources. In fact, if you have a tight NT configuration running COM objects can be a real problem because it needs a number of places where access is required:
* The location that the DLL lives in requireed Exec/Read for IUSR_
* The WinNt\System32 directory require Read/Write to write TEMP Files For IUSR_
* The TEMP directory reuiqres full rights for IUSR_
* Any data directories require full access.
By default this is not a problem because NT sets rights for Everyone at the root level. However, if an admin goes through and fixes this open policy COM objects are going to have major problems.
Network access is more complicated yet. IUSR_ never has network rights because it's not configured as a network access account. you can change that for the advanced account settings.
However, the best approach in this scenarioo is to put your COM component into MTS/COM+. There you can set the executiion context of the package by assigning a speicific user to it. But it'll run slower in MTS and there's more admin overhead in getting components installed and updated on the server (and debugged on the local machine).
+++ Rick ---
>Hello everyone,
>
>I am having a problem with my COM object locating my VFP database when I call it from an Active Server Page. The database resides on a Novell File Server. The COM object has been installed on a computer running IIS 4.0/NT Server. From the Web Server, the data path is \\AAAFDY01\SYS\AAA\DATA (with a mapped drive, F:\aaa\data).
>
>I have tried opening the database with the path hardcoded :
>OPEN DATABASE \\AAAFDY01\SYS\AAA\DATA\mydb.dbc
>or
>OPEN DATABASE F:\AAA\DATA\mydb.dbc
>
>but I am having no success. I have also tried adding the IUSR_ account to the Administrator group (I know this is a security issue, I'm only doing this for testing) but this doesn't make a difference either.
>
>The error message I receive from my COM object is Error No.1 'File F:\aaa\data\mydb.dbc does not exist.'
>
>Any suggestions?
>
>TIA