KB42520: Connecting to Salesforce after modifying the ODBC Data Source gives error [DataDirect][ODBC Salesforce driver] The configuration options used to open the database do not match the options used to create the database in MicroStrategy 11.x

• Strategy

This document shows issue that connecting to Salesforce after modifying the ODBC Data Source gives error [DataDirect][ODBC Salesforce driver] The configuration options used to open the database do not match the options used to create the database in MicroStrategy 11.x. The root cause is the configuration options used for creating the local embedded database files during the first connection do not match the new configuration options during the second connection.

SYMPTOM:
When running a report against Salesforce database, a user could experience the issue below.


Report: XXX
 
Job: XXX
 
Status: Execution Failed
 
Error: SQL Generation CompleteQueryEngine encountered error: Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. The 
configuration options used to open the database do not match the options used 
to create the database. Connection String: DSN=XXX;.. Error in Process method 
of Component: QueryEngineServer, Project Revenue Analystics. Job XXX, Error 
Code= -2147212544
 
Starting Time: XXX

CAUSE:
The configuration options used for creating the local embedded database files during the first connection do not match the new configuration options during the second connection.

ACTION:
Inside the odbc.ini file Linux or the advance tab in Windows, set the CreateDB = 1. If 1 is already taken by another Salesforce DSN use 2.

Comment

0 comments

Details

Knowledge Article

Published:

May 12, 2017

Last Updated:

February 26, 2024