>To find the who is long in use the USER_NAME() function. For the program and the ODBC connection i do not have this information yet. As soon as I get something I will give it to you.

Check out the source for sp_who or sp_who2.

-Mike