>>>>>Hi all,
>>>>>Is there anything left for me to do to prevent the "Not enough memory" error? Server is single core Xeon with 3GB RAM running Windows 2003 server. These are the settings:
>>>>>
>>>>>1. Server virtual memory is set to 4GB
>>>>>2. VFP tempwork folder is on a local D:\TEMPWORK
>>>>>3. SYS(1104) is sprinkled in the code.
>>>>>4. SYS(3050) has been set to 16, 64, 128, 256 and 512 but all these settings still gives the error.
>>>>>
>>>>>I would like to physically throw the vfp runtime dlls and exe across the room but that's not an option that's available to me. What else can I do?
>>>>
>>>>Did you try
>>>>

>>>>SYS(3050, 1, 512*1024*1024)
>>>>SYS(3050, 2, 512*1024*1024)

>>>>?
>>>
>>>Yep. I think that's the 512MB setting which still gives me the error.
>>
>>Do you know which line exactly produces this error or it's random?
>
>Not really as the error showed up as a VFP error message instead of our custom error handler. It occurs in both our applications when there is more than one RDP session running on the server.

Is the server a standard server running at most 2 simultaneous remote sessions, or has it been configured with licensed Terminal Server running in application server mode so it can support 3 or more sessions?

If the latter, you need to be careful when installing software. Usually the best way is to manually invoke Add/Remove Programs and install through that. I believe you can also use CHANGE USER /INSTALL and CHANGE USER /EXECUTE to switch your session between install and execute modes. If you don't do this, software you install may not work properly, or at all.

Can you view total memory use on the server while the RDP sessions are running? Is it possible there's a lot of stuff going on and that server actually is running out of both physical and virtual memory?

Do you have lots of large VFP tables and/or are you running SQL statements that may create large working sets? Maybe you could post some of these SQL statements here, there may be ways to restructure them to reduce intermediate result set sizes.