Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,979 questions
Issues connection to DB2 database from data factory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 44%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jason Pawkett
1
Reputation point
Attempting to connect to a DB2 database on an IBM AS400. I am following the instructions here: https://learn.microsoft.com/en-us/azure/data-factory/connector-db2?tabs=data-factory
But am getting this error:
The value of the property '' is invalid: 'Value does not fall within the expected range.'.
Value does not fall within the expected range.
I am able to create a linked server in SSMS for this database but am unable to connect through data factory using the same connection info.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee2022-12-02T03:09:28.963+00:00 Hello @Jason Pawkett ,
Thanks for the question and using MS Q&A platform.
Could you please confirm what is the integration runtime being used? Please use the relevant IR as per the guidance provide in the connector documentation:
Since you have mentioned AS400, could you please make sure the port configuration in connection string is correct as mentioned in the connector documentation:
Please let us know how it goes with above verifications.
Thank you
-
Jason Pawkett 1 Reputation point
2022-12-02T18:11:10.407+00:00 I have confirmed the AS400 is listening o port 446, and I am able to successfully open a telnet connection to it on port 446. I am also able to make an ODBC connection to the server on the default port, 446.
Thanks,
Jason -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2022-12-02T20:43:14.143+00:00 are you getting this on creating the Linked Server and clicking Test? Or are you getting it somewhere else?
-
KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee
2022-12-12T02:12:34.813+00:00 Hello @Jason Pawkett ,
As @Anonymous requested could you please confirm if you are getting this on while creating the Linked Server and clicking Test? Or are you getting it somewhere else? In case if you are still blocked I would recommend filing a support ticket for deeper investigation as there are multiple factors which needs to be verified. In case if you are blocked and if you don't have a support plan, please let me know here.
Thanks
-
Jason Pawkett 1 Reputation point
2022-12-12T16:16:23.48+00:00 Yes, it is happening when creating the linked server and clicking test.
-
Anonymous
2022-12-12T16:49:26.157+00:00 what Integration Runtime are you using? Does it have access to the DB2 server? I suspect you need a Self-Hosted IR if you are not using one.
Sign in to comment
Sign in to answer