If you access remote databases via ODBC, the connection to the remote server is given a name. You can use the name to drop the connection in order to cancel a remote request.
The connections are named ASACIS_conn-name, where conn-name is the connection ID of the local connection. The connection ID can be obtained from the sa_conn_info stored procedure. See sa_conn_info system procedure.