cannot display odbc query results in excel worksheet.

SOLVED

Login credentials work initially when doing query, and can see query results in Microsoft query window, but cannot move results to excel worksheet. Get "invalid user ID or password specified", and when click "OK" get "[Microsoft] [ODBC driver manager] Driver's SQL SetConnectAttr failed". Its almost like the login credentials are being checked twice, and are getting lost by the time the second check happens. A ODBC connection through Access can be established without issue. Setting up CRE 9.7 on server 2008r2 with excel 2003. Are planning to upgrade to newer versions, but in interm are using these versions. Any help with this query issue would be greatly appreciated. Thanks.