Unable to connect to Informix DB thru ODBC stage

[vinodlakshmanan]

Trying to connect to Informix DB that lies on different unix server than Datastage server. Able to access database thru dbaccess utility on unix server.

Following error is given when I try to connect thru Datastage

DSR.MetaGeta(GET.DSNINFO)(SQLConnect('tdb1','eureka')): BCI Error:
SQLSTATE=60,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver]1213

The DSN I am using is as follows:

[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

Here the informix server resides on another UNIX server (drysdale in the DSN) and the value of $INFORMIXSERVER is odsdvtcp.
Please let me know if this is a driver issue or its an Informix DB issue.

Vinod

[vinodlakshmanan]

Hi folks,
Please let me know if there is any solution to this; this is urgent and is an issue on a production server.

TIA,
Vinod

[ArndW]

Vinod,

urgent request need to go to your support provider. Nobody responded to your original question because the answer is not self-evident and more information is need to try to diagnose the issue. Error - 1213 seems to be "invalid number", but the error seems to be happening when the system is trying to connect.

Is this the first time that you are trying to connect to DB/2 via ODBC from the server? If not, what changed between the time it worked and the time it didn't?

[vinodlakshmanan]

Trying to connect to Informix DB for first time from that Unix server
Unix server has Informix Client version installed (7.30.HC4)

ODBC stage connects to say database "A" but does not connect to database "B" from that unix server.
Informix verison of DB "A" is 9.30 and DB "B" is 7.30

Is this an Informix or Datastage issue ?