Hi Victor,
I think I see where you're going with this and I apologise for the bad wording of my original question.
The problem is NOT that I cannot return SQL Server data because of a login problem. The problem is that the Executant COM Server is returning local data
instead of remote data.
I've got the MetaDBC table in the \WINNT\SYSTEM32 folder with the cRemoteDBC field set to the correct DBC. Specifically, my problem is that I can't find how to set the Executant COM Server to use the DBC specified in the cRemoteDBC field.
Any other thoughts?
Regards,
Liam
>On SQL Server are you using a Trusted Connection or are you using a specific username and password to access the database?
Liam O'Hagan
MCP VFP Desktop Apps