A fuller version of this error is:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: INVALID_LOGIN: Invalid username, password, security token; or user locked out
Salesforce user names are email addresses and have the format user@domain. Depending on how an ODBC driver supplies this user name, DG4ODBC / HSODBC may truncate the domain from the user.
If you are sure that the Salesforce authentication details are correct, i.e. you have verified your Salesforce ODBC data source outside of Oracle®, by using a test ODBC application such as isql, try replacing your ODBC driver with Easysoft's Salesforce ODBC driver.
The Easysoft driver enables you to supply both the user and domain portion of the Salesforce user name via Heterogeneous Services. For more information, refer to How do I connect Oracle® to Salesforce.com?.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.