Azure / Azure/Azure-DataFactory

DB2 linked service error with selfhosted IR

Open
#386 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
PowerShell
Stars
529
Forks
623
PR merge metrics
No merged PRs in 30d

Description

Trying to connect to a DB2 source via an selfhosted IR. DB2 is v. 11.5 and from the documentation it should be supported. However we are running into the following error

Have not received expected codepoint: EUSRIDNWPWD. SQLSTATE=HY000 SQLCODE=-1040

Facts:
- Running IR v5.17.8154.2
- DB2 server version is v11.5
- DB running on non-standard port -> 30214
- Can successfully connect to the DB2 server via telnet from the IR machine
- Can successfully connect to the DB2 server via DBVisualizer (using JDBC) from the IR machine
- Tried installing IBM drivers v11.1, v11.5 and v11.5.4 respectively prior to installing IR.
- Also tried using a ODBC linked service to DB2, with no luck.
- Tried to spin up a DB2 instance locally on our network and ADF seems to connect fine via IR. Local instance does not require SSL and otherwise using vanilla configuration.

Any idea what is going wrong here?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.