Troubleshooting
Problem
main_program: Fatal Error: Could not connect to datasource?? (-1; ods_owner; CON_PAEMS328; [IBM(DataDirect OEM)][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation.)
Resolving The Problem
This might indicate a genuine network issue, or a configuration problem.
Test the connectivity outside of DataStage:
a) cd $DSHOME
b) . ./dsenv
c) cd ../branded_odbc/example
d) ./example
This starts a simple program that prompts you for datasource name, user, and password, and tries to connect. Note the results -- does this succeed, or does it fail to connect?
Also try using telnet from the DataStage engine to the database host, using the hostname and port from the DSN:
telnet host port
If telnet comes back with a message like "Could not open connection to the host, on port nnnnn" then there is a network problem that will need to be investigated, or your .odbc.ini is not configured correctly for hostname and port.
Try using IP address in the DSN definition to see if this resolves the issue.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21624491