On 11/05/11 3:57 PM, Brandon Phelps wrote:
The main question is, how can I efficiently determine if a db object is usable?
put the actual execute SQL command calls in a procedure which checks for an error code, and if the error is of the connection variety, reopens the connection and retries the query a reasonable number of times.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast
