It's possible that disconnecting the client will not cause the connection to be dropped. Both ODBC and OLEDB do connection pooling. You might try using DBCC INPUTBUFFER(spid) to get the last command issued on the connection.

-Mike