Unable to connect to SQL server through DataStage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Lavanya B
Participant
Posts: 20
Joined: Mon Oct 30, 2006 12:32 am

Unable to connect to SQL server through DataStage

Post by Lavanya B »

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?
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

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).
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply