ODBC connection option for feature PSC00102444 - Forum - DataDirect Connect - Progress Community

ODBC connection option for feature PSC00102444

 Forum

ODBC connection option for feature PSC00102444

This question is not answered

Hi guys,

Does anyone know the 'hidden' DSN option to enable the following feature?

    knowledgebase.progress.com/.../PSC00102444

    Request to enhance the SQL Server Wire Protocol driver that uses a streaming protocol to cancel a query when using SQLFreeStmt(SQL_CLOSE) to cancel long running queries instead of using SQLCancel()

    After the SQL is executed, the server tries to push all rows to the wire all at once, streaming. If you just call SQLFreeStmt with SQL_CLOSE, it just drains the socket. If there are billions of rows, it takes a while.

    Enhancement request PSC00102444 has been implemented in the SQL Server Wire Protocol driver as a hidden connection option.

I can't find it anywhere in the documentation.

Thanks,
Jan

All Replies
  • Open the KB article and click on the "Internal Only" tab.

  • Please log a support case with Progress Technical Support and refer to the KB article. They can provide you the details of the hidden connection option.

    Regards,

    Rashmi