DataDirect ODBC Driver Performance degradation with KeepConnectionActive=1 setting

A performance degradation is being observed with the DataDirect SQL Server ODBC Driver 08.02.2804 when KeepConnectionActive=1.

  • Sep 3, 2026
  • Knowledge

Title
DataDirect ODBC Driver Performance degradation with KeepConnectionActive=1 setting
URL Name
datadirect-odbc-driver-performance-degradation-with-keepconnectionactive-1-setting
Article Number
000303709
Environment
Product: Progress DataDirect SQL Server ODBC Driver Version: 08.02.2804 OS: Linux Database: SQL Server Application: All supported applications
Question/Problem Description
Performance degradation is observed with SQL Server ODBC Driver 08.02.2804 when KeepConnectionActive=1.
The operation SQLDisconnect experiences an approximately two-second delay compared to prior driver version 08.02.1081, which does not exhibit this delay.
Performance is much faster in version 08.02.1081 (B1180, U0930).
Steps to Reproduce
1) Configure SQL Server ODBC Driver 08.02.2804 with KeepConnectionActive=1. 2) Establish a connection and execute a SELECT statement. 3) Disconnect the session and observe the delay during SQLDisconnect. 4) Compare timing with prior driver version 08.02.1081 under identical conditions.
Clarifying Information
  • SSL/TLS is enabled for the connection.EncryptionMethod=1 and AuthenticationMethod=1 are used.
  • OpenSSL library is updated in addition to the driver.
  • The environment includes Azure SQL and on-premises SQL Server.
  • No significant performance difference is observed in query execution or SQLFetch processing between driver versions. 
Error Message
Defect Number
XDBC-76666
Enhancement Number
Cause
The exact cause is not known at this time.
 
Resolution

Fixed in release 08.02.3061. Refer to “Progress DataDirect for ODBC release download and install instructions” for instructions on how to download and install the release.

Workaround
Setting KeepConnectionActive=0 improves performance, but may not be suitable for environments requiring persistent connections.
Notes

References to Other Documentation:

Progress DataDirect for ODBC for Microsoft SQL Server Wire Protocol Driver User's Guide, Connection option descriptions : Keep Connection Active

https://docs.progress.com/bundle/datadirect-microsoft-sql-server-odbc-80/page/Keep-Connection-Active.html

Keyword Phrase
Last Modified Date
9/3/2026 5:31 PM

Files(0)

Drop Files

    Was this article helpful?

    Related Articles

    Disclaimer

    The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

    Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.