Applications using SQL_API_SQLCANCELHANDLE should be recompiled for Windows 7 Service Pack 1, Windows Server 2008 R2 Service Pack 1 and later Windows releases

Every ODBC API (such as SQLCancelHandle) has an assigned ID called function ID. The function ID can be passed into the SQLGetFunctions API to know whether or not the specific function is supported by the driver.� This article explains the changes that have been made to the function ID for SQLCancelHandle� (SQL_API_SQLCANCELHANDLE) in Windows 7 Service Pack 1, Windows Server 2008 R2 Service Pack 1 and later Windows releases, and the actions you need to take to ensure your application continues to work in these environments.

The function ID of SQLCancelHandle has been changed from 1022 in Windows 7 and Windows Server 2008 R2 to 1550 on Windows 7 Service Pack 1, Windows Server 2008 R2 Service Pack 1, and later versions of Windows for interoperability reasons.

There is no behavior change in the API SQLCancelHandle. Overall, the change will only affect the behavior of SQLGetFunctions. Applications�that�use SQL_API_SQLCANCELHANDLE and compiled with the Windows 7 SDK header should be re-compiled after manually redefining that constant to 1550.

Drivers that use SQL_API_SQLCANCELHANDLE and compiled with the Windows 7 SDK header will continue to work without any problem on the affected Operating Systems since the ODBC Driver Manager never calls into the driver code with this constant. The ODBC driver manager regards that the driver supports SQLCancelHandle whenever the driver exports the API in the driver DLL.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.