Use the odbct tool to diagnose the connectivity problems.
To help you diagnose ODBC connectivity problems, the odbct tool verifies your system configuration by attempting to make a simple connection to the target.
The odbct tool has three parameters: a data source name (DSN), user ID, and password. This example shows a connection to the dcmssql DSN using the user ID joe and password joe21.
odbct DSN USERID PASSWORD odbct dcmssql joe joe21 Would you also like the output saved to a file?(Y/N): y Attempting Connection -------------------------- > Allocating Environment > Allocating Connection > Attempting Connection DSN: dcmssql USER: joe PASSWORD: joe21 > CONNECTION SUCCEEDED > Allocating Statement > Connection succeeded, would you like to proceed with datasource and datatype reporting? (Y/N): n Connection Cleanup -------------------------- > Free Statement > Attempting Disconnection + Disconnection succeeded > Free Connection > Free Environment belford [ 23 ]