Salesforce ODBC Unable to login
Posted: 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?
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?