ODBC call error In sap bods

[former_member241220]

Hi All,

My job failing due to below odbc call error. But my database is DB2. I never used ODBC to connect my DB2 database.I crated data store through port, But I am getting ODBC error, Please let me know why I am getting this error and how to solve this

Error:

(14.2) 10-30-16 05:45:42 (E) (3316:4892) CON-120307: |Data flow DF_DB2_HAND_FINNE ODBC call <SQLDriverConnect> to connect database <DEDB2A> failed with error: <[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "172.21.205.17". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001 >. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.

Thanks

Murali

[aasavaribhave]

Assuming you are on Linux - have you used run $LINK_DIR/bin/DSConnectionManager.sh to define the DB2 driver - this error is expected if driver not defined properly or any connection parameters are wrong. The error message is sort of generic - you will get it for ODBC as well as native client calls.