Is it the RODBC connection which is taking a long time or the time to retrieve queries?
You can generally use different connection packages which have differing read/write performance, but I would be surprised if the connection itself made a significant difference - this should only be a few seconds to verify the user details supplied.