Hi!

HOW you mapped that drive and path for another user on that machine? Mapped drives are applied for current logged on user only. So when you logged on as user "ME", mapped drive will be available only to all applications that run under "ME" user account. ASP pages run under the account defined for WEB service (IIS). So you have to log on on the computer as that user at least once, map some share to drive and set up it to do mapping automatically at logon, then logout. In addition, IIS service account must have proper security rights in the network domain to have access to network resources, as well as it should have access rights to the mapped share and files in folders there. This is hard to organize, but possible - you require to create a network user accound with the same name as used for IIS, then reconfigure the IIS to use that account. Beware - allowing the IIS to access network resources is a very dangerous hole in the security in case you will not handle security rights properly for the user account used for IIS.

You can also use just the UNC name, so no mapping ia required:
\\SOMEMACHINE\SOMESHARENAME\data\euc.dbc

Finally, you can set up IIS to work unde "ME" account, but for sure this is even greated hole in the security.

HTH.

>I am trying to access a VFP database but I get an error :
>My ASP pages is locate in my local machine and the database in a remote server.
>
>Here is the error:
>
>Error Type:
>Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
>Invalid path or file name.
>/ehs_lookup/lookup.asp, line 28
>
>Here is the connection code :
>

>Set oRecordset = Server.CreateObject("adodb.recordset")
>Set oConnection = Server.CreateObject("adodb.connection")
>oConnection.Mode = 16
>
>oConnection.ConnectionString = "Provider=VFPOLEDB.1;Data Source=f:\data\euc.dbc"
>
>oConnection.Open
>

>
>The path is a mapped drive on my local computer.
>
>Any help is greatly appreciated.
>
>Thanks,
>Sergio Ortiz