>Hi All:
> I am creating an .EXE from a source files which are located on Sql Server 7.0. If I am mapped to the drive where my source files are located, my .EXE runs fast, however if I remove the drive mapping to my source files, the .EXE runs very slow. There is no code in my project that would reference the source files. Then why do I need to mapped to the drive where the source files are located in order for my .EXE to run fast? Is this a Sql Server 7.0 thing? How can I solve this problem?
>Thanks
Because I am uncertain what actually your problem is, I will just explain what I have understand. Correct me, if I am wrong.
You have an VFP application, which queries against SQL Server 7.0. The source code of that application is located at the same machine, that runs SQL Server 7.0. When you have drive mapping to the drive, where the source code is located - the EXE runs faster. So you ask why it runs slower without such a mapping.
Try the following, if you have more than one drive on the server: map a drive, that does not have the source, and check whether you exe runs slower/faster.
What kind of SQL Server user authentication do you use? Windows trusted or both SQL Server and Windows trusted?
Do you create objects from your classes dynamically (e.g. with CreateObject, Newobject or AddObject)?
HTH
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!