Connecting to SQL after a long period of downtime
Posted on 2004-10-18
Ok, I wrote a program that stays constantly open on a desktop for 24/7 during a work week. Basically it swipes in and out users (like a punch clock). So for example, someone will enter in their employee ID at 6:00 AM and then again at 3:00PM when they leave.
It works perfectly, other than the FIRST person to use it at the beginning of the day, it takes a few seconds for the program to do something (Either connect to the DB or somethign to do with Garbage Collection) so when the first person uses it , they think there is something wrong with it and try to punch in "multiple" times. I've tried putting in "Please wait" messages, but i stil have the same problem
I guess my question is...how to make them wait while the system connects...? i've tried putting in a "Please wait" message, but the system just logs them in multiple times still.
Is there a way to stop all the processes until its connected, or ?
Thanks in advance.