DSXchange

Is the machine "p2lp18" your DataStage engine Tier? - Yes To which working database did you try to "ping"? - Yes. I ping'ed the MySQL connection in our engine tier which is p2lp18 and I got a one liner result. I also tried it in our database that we already using in DataStage but...

I tried the same step on the database we already using in DataStage, but I got the same result.

After trying it , this is the result

dsadm@p2lp18:/home/dsadm>ping 13.250.184.188
PING 13.250.184.188: (13.250.184.188): 56 data bytes

then nothing is happening after that one liner result

I have configured the odbc.ini to connect to mysql database, but when trying testing it I received a Connection Failed error Error Message: ODBC function "SQLConnect" reported: SQLSTATE = HY000: Native Error Code = 2,0003: Msg = [IBM(DataDirect OEM)[ODBC MySQL Wire Protocol driver] Can't c...