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
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