added password auth handling to the connection object to handle pooled connections and re-connections