Does anyone know how to determine the computer name of the current ODBC connection.

For instance, I am connecting over a WAN to an ODBC Data Source via ADO. I want to know the computer name of the machine that I am connecting to. The user can change to DSN to connect to different machines, and I want to be able to determine the computer name of each machine.

If I was able to determine SQL Servers in a network on a 95/98 machine that would work too.

Thanks


James Kline
Simonton Windows, Inc.