Hooray!!, I manged to get a DCOM object to execute a SQL query.
When the resulting DBF is saved on the Server, it works perfectly. However if I try to get it back to the Client, it sometimes gives OLE errors. For eg the follwing will give an error

oMyDCOM.GetSQL("Select * From Customer INTO \\MyComputer\C\MyResult")

However the following will allways work

oMyDCOM.GetSQL("Select * From Customer INTO MyResult") && in which the result set is stored on the server. Any ideas on what the problem is?
Note: Backend = VFP