Larry,
I experienced the very same symptoms a couple of years ago, running
7.5 compiled.
I was able to resolve my issue, however I modified more than one
possible cause, so I'm not 100% sure which fixed it. So I will list
what I did and perhaps, where applicable, one might help.
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.
Anyway, after the above, my issue went away. I could introduce one
back in at a time, but the system is working great and I do not have
the time for that luxury.
I suspect the ODBC changes were probably causing my iisues, but it
could have been any of the above.
Good luck.
Bob Thompson
LaPorte, IN
219-363-7441
Sent from my iPod
On Oct 18, 2011, at 8:07 AM, Lawrence Lustig <[email protected]>
wrote:
A client has recently started having problems with their R:Base
system "hanging" -- all attached sessions stop running and the
database files become unavailable until the server is rebooted.
I believe that the onset of this problem more or less coincides with
their changing some machines in their facility from networked
workstations to thin clients attaching to RDP sessions.
I'm wondering if dropped or incorrectly terminated RDP sessions
could account for the sudden onset of problems they're seeing. Does
anyone have an experience with this?
--
Larry
