ConnectionTimeout in ODBC Data Direct driver level in SiteMinder
Article ID: 282181
Updated On:
Products
Issue/Introduction
Via registry it is possible to define in CA SiteMinder parameter ConnectionTimeout which will take care of the unresponsive connections between the application and the database. It is also possible to configure ODBC Data Direct driver setting LoadBalanceTimeout for taking care of idle connections (1). One of the important differences between both settings is that LoadBalanceTimeout works at network level, whereas ConnectionTimeout is meant for the SiteMinder application itself
The question is whether there is any parameter for ODBC Data Direct driver which would be the equivalent to ConnectionTimeout
Environment
CA SiteMinder all versions
Resolution
As per Data Direct Documentation, there is no setting in driver configuration which will behave like the SiteMinder ConnectionTimeout registry setting (2)(3).
The Driver works at network level so it is agnostic as to how the Application manages connections.
Additional Information
- Please see:
https://knowledge.broadcom.com/external/article?articleNumber=136252 - Connection Options for Data Direct Oracle ODBC driver 8.0:
https://docs.progress.com/bundle/datadirect-oracle-odbc-80/page/Connection-option-descriptions.html - Sample ODBC.ini for Oracle Data Direct Driver:
https://docs.progress.com/bundle/datadirect-oracle-odbc-80/page/Sample-default-odbc.ini-file.html
Feedback
