skip to main content
Part 4: The Connect XE Drivers : The Salesforce Driver : Connection Option Descriptions : Initialization String
  
Initialization String
Attribute
InitializationString (IS)
Purpose
One or multiple SQL commands to be executed by the driver after it has established the connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver returns an error indicating which SQL command or commands failed.
Valid Values
string
where:
string
is one or multiple SQL commands.
Multiple commands must be separated by semicolons. In addition, if this option is specified in a connection URL, the entire value must be enclosed in parentheses when multiple commands are specified.
Example
Because fetching metadata and generating mapping files can significantly increase the time it takes to connect to Salesforce, the driver caches this information on the client the first time the driver connects on behalf of each user. The cached metadata is used in subsequent connections made by the user instead of re-fetching the metadata from Salesforce. To force the driver to re-fetch the metadata information for a connection, use the InitializationString property to pass the REFRESH SCHEMA SFORCE command in the connection URL. For example:
DSN=Salesforce;UID={test@abccorp.com};PWD=secret;InitializationString=(REFRESH SCHEMA SFORCE)
Default
None
GUI Tab
Advanced tab