>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?
The odds are that the anonymous user id used to execute the DCOM server doesn't have permissions on your local share.