Salesforce ODBC Unable to login

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
EnvisionIT
Posts: 2
Joined: Mon 13 Jul 2015 04:39

Salesforce ODBC Unable to login

Post by EnvisionIT » Mon 12 Mar 2018 05:23

We are going to convert our existing CRM / MSSql software to Salesforce. I will be using the ODBC driver to import the data.

I created a developer account to test with, and have approved my IP address in the setup.

I got my User ID from the string https://na50.salesforce.com/01234567890 ... redirect=1 (everything after the / and before the ?

I reset my security token

I select Production (login.salesforce.com), my userid, my password and Security Token and when I try test connection I get:

"[Devart][ODBC][Salesforce]Invalid username, password, security token; or user locked out"

I've triple checked and my values are correct! Is there some other security options I have to enable in Salesforce to enable ODBC access?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Salesforce ODBC Unable to login

Post by MaximG » Mon 12 Mar 2018 12:06

To connect to Salesforce using our driver, it's enough to use three parameters: "User ID", "Password" and "Security Token". First, check the first two parameters correctness. For this, use your "User ID" and "Password" to sign in to the login.salesforce.com page. In case of successful authentication on this page, use the instruction specified in our documentation
( devart.com/odbc/salesforce/docs/obtaining_token.htm ) and get a new value for "Security Token" again. After that, specify all three parameters in the DSN settings of our driver.

Post Reply