If you are using ADO, why use ODBC? You can establish a DSN-less connection using ADO.

If that does not solve the speed problem, check for your network speed, whether you are using server-side recordsets or client-side recordsets etc.