To help you diagnose ODBC connectivity problems, the odbct tool verifies that your system configuration is by attempting to make a simple connection to the target.
Be sure to run the odbct tool in
the same environment in which you plan to use DirectConnect for
Microsoft SQL Server, DRDA, or Informix targets by executing the DC_SYBASE.bat.
The odbct tool has three parameters: a data source name (DSN), user ID, and password. The following 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 procede with datasource and datatype reporting? (Y/N): n Connection Cleanup ------------------------------------------------------> Free Statement> Attempting Disconnection + Disconnection succeeded> Free Connection> Free Environmentbelford [ 23 ]
