>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?
make an explicit connection to the UNC using WNetAddConnection2() or WNetAddConnection3(), which allow you to specify a userid and password for the connection - it's unlikely that the IUSR_machinename account has privileges on another machine or in a domain unless you've explicitly taken steps to establish such accounts. IUSR_machinename is a local account, not a domain account, and won't have domain privileges or corresponding accounts on other peer stations.