ODBC connection option for feature PSC00102444

Posted by jfsav on 20-Mar-2018 07:45

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

Posted by John Sullivan on 12-Jun-2019 14:00

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

Posted by Rashmi Gupta on 12-Jun-2019 16:22

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

This thread is closed