This string includes the options used to connect using basic user name and password authentication.
Note: The strings demonstrated in this section use the DSN-less format. For additional formats, see Using a connection string. 
DRIVER=DataDirect 8.0 Salesforce;HostName=hostname;LogonID=user_name;Password=password;
       SecurityToken=security_token;[attribute=value[;...]];

where:

hostname

the base URL or IP address of the Salesforce instance to which you want to connect. If you are logging into a Salesforce instance other than the default, you must provide the root of the Salesforce URL or IP address. The default is login.salesforce.com.

user_name
specifies the user name that is used to connect to your Salesforce instance. For example, jsmith@example.com.
password
specifies the password used to connect to your instance.
security_token
specifies the security token required to make a connection to a Salesforce instance that is configured for a security token.
attribute=value
specifies connection option settings. Multiple option attributes are separated by a semi-colon.
Note: The User, Password, and Security Token options are not required to be stored in the connection string. They can also be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the connection string.

The following example connection string includes the options required for connecting with user ID and password authentication:

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