Connectivity Problems

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.

Note: Be 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 ]