Using the odbct tool for ODBC 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.

NoteBe sure to run the odbct tool in the same environment in which you plan to use ECDA targets by executing DC_SYBASE.csh.

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 ]