You can use the odbcping utility to check whether ODBC is properly installed by connecting to a server using the Microsoft® SQL Server™ ODBC driver. This utility is a 32-bit application stored in the \Mssql7\Binn directory.
To verify ODBC connectivity