MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for ODBC
A new data source information property, DBPROP_SERVER_NAME, is now supported by the OLE DB Provider for ODBC. This property returns, upon initialization, the name of the server to which you are connected. In many cases, this will be the same as the DBPROP_INIT_DATASOURCE property. For example, when connecting to an ODBC data source you might specify a DSN (friendly name), and the server name would return the name of the actual server to which you were connected.