> Is there a way to test a connection prior to using it to find out if > it's actually open? Like pinging the active connection. > > If I could do something like that prior to returning the connection, I > could then loop through the connections to check until I get a good > one. We have all of the general login in place, but the assumption was > made that the connection state was real time, which is now known to be > false. > > Any ideas/assistance would be greatly appreciated.
As mentioned via the quick PM back... There is a ping. When I stop using IDBConnection and go with MySqlConnection there is a Ping() that doesn't exactly that. I guess I've been spending too much time on the MS and Oracle providers... Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org