Easysoft ODBC-Salesforce Driver

Why do I get error ORA-28500: INVALID_LOGIN: Invalid username, password, security token; or user locked out?

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

You will get this error if you are using the Oracle Heterogeneous Services agent DG4ODBC / hsODBC to connect Oracle to Salesforce and:

• Your Salesforce ODBC driver data source contains an invalid Salesforce user name, password or security token.

  –Or–

• Your Salesforce ODBC driver does not provide a mechanism for you to send a complete Salesforce user name to Salesforce.

  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?.

Applies To

• Products
  • Easysoft ODBC-Salesforce Driver
• Applications
  • Oracle

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•