By default, the Salesforce ODBC driver connects to the Salesforce login server, which then connects to your production Salesforce server. To connect to your Salesforce sandbox, you need to bypass the login server and connect directly. To do this edit or create a new Salesforce ODBC driver data source.
On Windows, create or edit the data source in ODBC Data Source Administrator. Change the Logon URI attribute value.
On Linux and UNIX, create or edit the data source in odbc.ini
, which, by default is located on /etc
. Change the URI
attribute value.
Replace login
in the attribute value with test
. The new URI will look similar to this:
https://test.salesforce.com/services/Soap/u/34