I know how to create an ODBC connection string and include a fixed WSID reference in the string but I want the WSID to be picked up automatically at runtime from the computer that the program is being run on. The reason I need this is so I can look at the MS SQL Server Enterprise Manager and see any hung processes and be able to identify the workstation where the program is hung..

Thanks,
Robert Wright