skip to main content
Getting Started : Configuring and Connecting on UNIX and Linux : Configuring a Data Source
  

Try DataDirect Drivers Now

Configuring a Data Source

The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.
The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, and yy represents the extension. The values for the options are samples and are not necessarily the ones you would use.
[ODBC Data Sources]
Salesforce=DataDirect 8.0 Salesforce
[Salesforce]
Driver=ODBCHOME/lib/xxsfrc28.yy
HostName=test.salesforce.com
UserName=JohnDoe
Password=secret
SecurityToken=XaBARTsLZReM4Px47qPLOS
Connection Option Descriptions:
*HostName: The URL or IP address of the Salesforce instance to which you want to connect. The default is login.salesforce.com.
*UserName: Your logon ID for Salesforce
*Password: Your case-sensitive password for the Salesforce instance.
*SecurityToken: If required by your instance, your case-sensitive security token for the Salesforce instance.