Query analyzer does not use ODBC DSN, so if you can't connect to your server using Query Analyzer then it must be the login that has the problem not the ODBC driver.

In your server check the default database for the login account your trying to connect with, and make sure the login has access to the default database.