DSXchange

Hi,
The DataStage server is on unix.
We are unable to connect to SQL server through DataStage.
We are trying to import table definitions using ODBC table definition. After selecting the DSN from the drop down list and giving the username and password and clicking Import, we get an error message-
SQLSTATE = S1T00
NATIVE ERROR = 0
MSG = [IBM(DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Timeout expired. select failed: 0

We have created the DSN in .odbc.ini file present in $DSHOME and added the DSN in uvodbc.config file in the project directry.

Apart from changing/modifying the above mentioned files, are there any other configurations to be done?

There are no other files to configure. Double check that the .odbc.ini entry has correct database name, host name (or IP address), and port number.

Timeout errors usually indicate you are blocked by a firewall. Make sure if there is a firewall that you have a rule to allow the network traffic.

Also use the example program to check your connection from the command line. It is located under the branded_odbc directory, which is up one level from $DSHOME. The example program is usually under a branded_odbc/samples subdirectory. Source the dsenv file before running the example program to set your environment variables. From the $DSHOME directory, run command ". ./dsenv" (starting with a dot-space).