This was the response that Bob made to an earlier question: -------------- Terminal Server nodes hang up and leave open sessions: (from Bob T) ODBC connections: My database had several ODBC connections to non-Rbase tables. Some of these were originally attached without a "using" clause. This resulted in all columns being a "Qualkey" link in these tables. I corrected this to have only one QualKey column.
I also changed code to DisConnect ODBC connections after use where ever I could, not leaving them open "all day" Temp files: I originally was using a shared TEMP folder for all RDP user's $$$ files. I changed the code to use the user's Windows RDP profile temp folder. I set the RDP user's rights to full for the shared Database folder. (This added erase authority, but I was grasping for solutions) Compiled file: I had about 20 RDP sessions running from 1 shared folder and compiled .exe. I made 4 duplicate folders and went to about 5 users per .exe. This might seem strange, but I had reasons to suspect some odd trerminal server issue running so many copies of the same exe. -------------- I had also saved this posting that Kenny made a while ago: We have approx 35 Citrix/RDP sessions running on Two Citrix/RDP running 2008 using a Citrix Access Gateway to balance the load. We found that after we went to Sever 2008 (from 2003) that ocassionaly the users were unable to load a compiled exe after a user had logged out. The error was "unable to load application". We found that this only happened when user 0 logged out and it appeared that the drive mapping had been removed from all currently attached users. At first we would login first on each server to reserve user 0 and not log out all day. We were finally able to work around this issue by installing the compiled exes to each of our two Citrix/RDP servers on a local directory, instead of mapping to the exe located in the shared database directory on a different 2008 server. Our research pointed to a Windows issue stating that RDP only uses one MCB (Master Control Block) for all users? (Trust me, I don't totally understand this issue). So know I have three copies of each exe I must replace each time I recompile. Since we mapped the exe local to the Citrix/RDP server the system has been very stable. Moving from Sever 2003 to 2008 was quite an experience. Karen In a message dated 1/19/2012 7:14:12 AM Central Standard Time, [email protected] writes: > Can somebody repost the list of > Bob Thompson bag of RDP tricks? I want to start using RDP, no point in > reinventing the wheel. > Mike
