I have a stored prcoedure that checks for connections with a very old
lastreqtime and then disconnects them. I wanted to add a bit more
intelligence in that it will check to see if the connection is still
valid. I thought I would do this by having the connection execute a
basic sql command against the DB (select 1 from dummy) and then
checking the DB return code. However, I can't seem to find a way of
executing a sql statement on a specific connection (using conn ID).
Is this possible?
Using ASA7 on Win2K
Thanks,
Lou