To configure the driver to use basic authentication:
  • Set the Authentication Method (AuthenticationMethod) option to 0 (UserIDPassword), which is the default.
  • Set the User (LogonID) option to specify the default user ID and domain that is used to connect to your Salesforce instance. For example, jsmith@example.com
  • Set the Password (Password) option to specify the password that is used to connect to your Salesforce instance.
  • Optionally, set the Security Token (SecurityToken) option to specify the security token for instances that require one.
  • Optionally, specify values for any additional options you want to configure. See "Connection option descriptions" for a complete list of options.

The following examples demonstrate a connection using user id and password authentication enabled with a security token requirement:

Using a connection URL:

DRIVER=DataDirect 8.0 Salesforce;HostName=login.salesforce.com;LogonID=jsmith@example.com;
       Password=secret;SecurityToken=XaBARTsLZReM4Px47qPLOS

Using an odbc.ini file with the 32-bit driver: 

Driver=ODBCHOME/lib/ivsfrc28.so
Description=My Salesforce Data Source
...
HostName=login.salesforce.com
...
LogonID=jsmith@example.com
...
Password=secret
...
SecurityToken=XaBARTsLZReM4Px47qPLOS
...