>>If I'm looking for reliability I have connections open only the bare minimum amount of time needed to communicate with the backend. It used to be expensive to frequently connect and disconnect like that, but my understanding is modern versions of RDBMSs cache or pool connections so there's not much impact.
>
>Yes, this is what I recommanded. But, I was just trying to see if this is a normal behavoir that it reacts like that.
Check DispLogin property
SQLSETPROP(0,"DispLogin",3)
There is another one, I think. Try Searching this site, I forgot at the moment.
If it's not broken, fix it until it is.
My Blog