My questions and suggestions below are in blue

>I have two servers. On one server I have the sorurce codes for the VFP app and on the other server I have the live data.

Which of the two servers is Domain Controler (has the Active Directory installed on it and provides user logon services)?


>If I mapped a drive to the server where my vfp app source codes are located, the EXEC runs faster, however if I do not mapped a drive to the server where the source codes are located, the exec runs slower.

Have you tried to have a mapped drive, that does NOT have the source on it?
If in that case your source code runs faster - it means that the problem is with SQL trusted connection. If this is the case, I suppose that you try to login to server with SQL Server native connection.


>I am using Window trusted authentication and yes I do create objects dynamically.

If the only case, when your code runs faster, is when you have mapped drive to your source, try compiling your program to EXE, moving your source to another direction and running the EXE after the source is not available in its old directory to identify which object creation depends on your VCX files. I am not sure that the above procedure will identify you problem but try it.


>Thus, how can I solve this problem?
I donot know :). Have you read my comments above? Please test the suggestions and report the result.

Best Regards