Following error is given when I try to connect thru Datastage
The DSN I am using is as follows:DSR.MetaGeta(GET.DSNINFO)(SQLConnect('tdb1','eureka')): BCI Error:
SQLSTATE=60,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver]1213
Here the informix server resides on another UNIX server (drysdale in the DSN) and the value of $INFORMIXSERVER is odsdvtcp.[tdb1]
Driver=/appl/datastage/Ascential/DataStage/branded_odbc/lib/VMifcl19.sl
Description=DataDirect Informix Wire Protocol
Database=tdb
LogonID=eureka
Password=
HostName=drysdale
PortNumber=8033
ServerName=odsdvtcp
Protocol=onsoctcp
ApplicationUsingThreads=1
TrimBlankFromIndexName=1
CancelDetectInterval=0
CursorBehavior=0
GetDBListFromInformix=0
EnableInsertCursors=0
Please let me know if this is a driver issue or its an Informix DB issue.
Vinod