Cursor Error w/ ODBC SQL2000

My office inherited a legacy VB6 program that connects via a MSRDC to
a SQL2000 server. The original ODBC connection pointed to a legacy
Win2000 Adv Server w/ SQL2k, we have upgraded a test server Win2k3 w/
the same SQL2k. The previous server didn't have a password, so on the
new one we included a password, and made all the changes in the ODBC
connection. The ODBC test returns successful. Unfortunately, with
the new password the application says, "Invalid Logon".

With a blank password, however, the VB6 applicationspams the
following:

Environment-setup
Error 40002 - 37000: [Microsoft][ODBC SQL Server Driver][SQL Server]
The cursor was not declared.

MSRDC1
37000:[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was
not declared.

Any ideas? I've been all over google ... seems like everyday there's
less VB6 info out there ... any help would be great!