Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


ConnectionRetryCount and ConnectionRetryDelay parameters do not work for SQL Server ODBC connections
Problem Description
Workflow fails intermittently in production because of connection failure. The user is using ODBC connection for Target database and it fails while connecting to the database. On re-running the workflow, it is successful. To avoid manual intervention, the user uses ConnectionRetryCount and ConnectionRetryDelay parameters in the odbc.ini file, which is used to retry the connection on failure. 


Data Direct confirmed that it is a bug and will be providing a one-off fix for ODBC 7.0 and ODBC 7.1 versions. ​​A case was raised with DataDirect to confirm if it is a bug. (Case number: 00287682).
If there is an HA license for the user environment, Informatica provides retry count which tries to connect to the database on failure. This ODBC fix has been added to Informatica 9.6.1 Hotfix 3.
More Information
Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter
Operating System:
Other Software:

Last Modified Date:1/8/2019 9:04 PMID:321239
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)