I want to use a working fox COM object as a DCOM object, but the pathing seems to be different! All the NON pathed functions are working 100% .

For security and maintenance reasons, I want the object to reside on my data server, not on my WEB CONNECT server or clients' systems.

Here's the rub

The COM server code has lines like

mydrive="C:" && the real values are actually in a table
mypath="\data\"
myfile="test.dbf"
tfile=mydrive+mypath+myfile
IF FILE(tfile)
tc_message="Loaded " + tfile
USE &tfile
ELSE
tc_message= "ERROR -unable to locate " + tfile
ENDIF
RETURN tc_message

tfile loads in both createobject() AND createobjectEX()

Changing to mydrive="\\myOtherServer" the COM works, the DCOM fails to locate the file and returns the error message!

This does NOT seem to be a network permission issue, because it fails
with createObjectEX() when I am testing with all files and code actually at myOtherServer.


If this belongs on another thread, please move it, but I really don't know if the problem is VFP or Winapi or OLE or ??
ANy ideas out there?