Failed to connect to the database. DB2 -Azure data factory

Question

Failed to connect to the database. DB2 -Azure data factory

Sridhar Hariharan-CIC 21

Hi,
Have started using Azure trial subscription, As part of this Azure Data factory resource is created and would like to explore extraction part from the source. Have installed Integrated runtime (Selfone) and could see options (Diagnostics -> DB2 ->Entered IP/ Port , Databasename, Credentials ) but its failing with Failed to connect to the database. Error message: The type initializer for 'Microsoft.HostIntegration.Common.TelemetryClient' threw an exception.
Could not load file or assembly 'file:///C:\Program Files\Microsoft OLE DB Provider for DB2\System\Microsoft.ApplicationInsights.dll' or one of its dependencies. The system cannot find the file specified.

How to fix this one?
Regards
Shreedhar.

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-08T05:58:58.91+00:00

Hello @Sridhar Hariharan-CIC ,

Welcome to the Microsoft Q&A platform.

Could you please share the DB2 version which you are using?

Make sure you have selected the right properties while using DB2 linked service.

Meanwhile you can checkout this article (Copy data from DB2 by using Azure Data Factory) outlines how to use the Copy Activity in Azure Data Factory to copy data from a DB2 database.

Please do let us know if you are still facing the issue .
Sridhar Hariharan-CIC 21 Reputation points

2021-06-08T07:09:11.767+00:00

Hi Pradeep,
Thanks for your response. Version is v12.0. Also verified was able to establish db connection through "OLEDB driver" locally. Pls check and comment your inputs to fix the issue. If this works we would see further exploration.

Regards
Sridhar
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-08T09:24:03.37+00:00

Hello @Sridhar Hariharan-CIC ,

Thanks for the details.

Could you please creating a DB2 linked service from Azure Data Factory and see if you see the same error message?
Sridhar Hariharan-CIC 21 Reputation points

2021-06-08T09:38:26.49+00:00

Hi Pradeep,
Thanks for your help. Yes i tried the same , same message is shown (Test connection) through self hosted runtime (IR). I did both the ways (Diagnostics and tried to connect DB2 server using DB2-OLEDB, ODBC ) and then tried in Azure Data Factory linked service to connect the same. In all the ways received same message.
Regards
Sridhar
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-08T10:40:17.19+00:00

Hello @Sridhar Hariharan-CIC ,

Thanks for the confirmation.

We are reaching out to internal team to get help on this issue and will update you as soon as we have a response.

Thank you for your patience.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-10T03:50:50.16+00:00

Hello @Sridhar Hariharan-CIC ,

We are still awaiting for the response from the internal team. I will update you as soon as we have a response.

Stay tuned!
Sridhar Hariharan-CIC 21 Reputation points

2021-06-14T05:10:29.83+00:00

Hi Pradeep,
Do you have any updates from the concerned team?
Thanks
Sridhar
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-14T06:04:56.44+00:00

Hello @Sridhar Hariharan-CIC ,

We are still awaiting for the response from the internal team. I will update you by end of today.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-15T03:30:42.613+00:00

Hello @Sridhar Hariharan-CIC ,

Outside ADF, have you installed Db2 OLEDB provider correctly and tested connectivity using data access tool?

Data Access Tool - Host Integration Server | Microsoft Learn
Sridhar Hariharan-CIC 21 Reputation points

2021-06-15T04:42:15.617+00:00

Hi Pradeep,
Yes. DB2OLEDB -Data access tool is working fine .I am having couple of data sources and all of them are responding test connection successfully establishing the connection and sample query is fetching the results in the Grid. Hope IR-DB2 option is trying to connect through OLEDB driver. OLEDB version is 6.0.

Regards
Sridhar

Accepted answer

1 additional answer

Your answer

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-08T05:58:58.91+00:00

Hello @Sridhar Hariharan-CIC ,

Welcome to the Microsoft Q&A platform.

Could you please share the DB2 version which you are using?

Make sure you have selected the right properties while using DB2 linked service.

Meanwhile you can checkout this article (Copy data from DB2 by using Azure Data Factory) outlines how to use the Copy Activity in Azure Data Factory to copy data from a DB2 database.

Please do let us know if you are still facing the issue .
Sridhar Hariharan-CIC 21 Reputation points

2021-06-08T07:09:11.767+00:00

Hi Pradeep,
Thanks for your response. Version is v12.0. Also verified was able to establish db connection through "OLEDB driver" locally. Pls check and comment your inputs to fix the issue. If this works we would see further exploration.

Regards
Sridhar
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-08T09:24:03.37+00:00

Hello @Sridhar Hariharan-CIC ,

Thanks for the details.

Could you please creating a DB2 linked service from Azure Data Factory and see if you see the same error message?
Sridhar Hariharan-CIC 21 Reputation points

2021-06-08T09:38:26.49+00:00

Hi Pradeep,
Thanks for your help. Yes i tried the same , same message is shown (Test connection) through self hosted runtime (IR). I did both the ways (Diagnostics and tried to connect DB2 server using DB2-OLEDB, ODBC ) and then tried in Azure Data Factory linked service to connect the same. In all the ways received same message.
Regards
Sridhar
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-08T10:40:17.19+00:00

Hello @Sridhar Hariharan-CIC ,

Thanks for the confirmation.

We are reaching out to internal team to get help on this issue and will update you as soon as we have a response.

Thank you for your patience.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-10T03:50:50.16+00:00

Hello @Sridhar Hariharan-CIC ,

We are still awaiting for the response from the internal team. I will update you as soon as we have a response.

Stay tuned!
Sridhar Hariharan-CIC 21 Reputation points

2021-06-14T05:10:29.83+00:00

Hi Pradeep,
Do you have any updates from the concerned team?
Thanks
Sridhar
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-14T06:04:56.44+00:00

Hello @Sridhar Hariharan-CIC ,

We are still awaiting for the response from the internal team. I will update you by end of today.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2021-06-15T03:30:42.613+00:00

Hello @Sridhar Hariharan-CIC ,

Outside ADF, have you installed Db2 OLEDB provider correctly and tested connectivity using data access tool?

Data Access Tool - Host Integration Server | Microsoft Learn
Sridhar Hariharan-CIC 21 Reputation points

2021-06-15T04:42:15.617+00:00

Hi Pradeep,
Yes. DB2OLEDB -Data access tool is working fine .I am having couple of data sources and all of them are responding test connection successfully establishing the connection and sample query is fetching the results in the Grid. Hope IR-DB2 option is trying to connect through OLEDB driver. OLEDB version is 6.0.

Regards
Sridhar

Answer 1

SandipKhandelwal-MSFT 96 Microsoft Employee

Hello Sridhar,

Somehow dependent DLL i.e. Microsoft.ApplicationInsights.dll is missing from installation OLEDB provider installation path : C:\Program Files\Microsoft OLE DB Provider for DB2\System

Steps to get DLL :

Go to nuget package portal : https://www.nuget.org/packages/Microsoft.ApplicationInsights
Download package Microsoft.ApplicationInsights
Change extension to zip
Extract package
DLL Microsoft.ApplicationInsights.dll should be present in library : microsoft.applicationinsights.2.17.0\lib\net46
Copy this DLL to library : C:\Program Files\Microsoft OLE DB Provider for DB2\System and try again.

Thoman, Nick 61 Reputation points

2023-10-11T18:53:03.68+00:00

This fixed my issue. Thanks.

Answer 2

@Sridhar Hariharan-CIC ,

 Did you have OLEDB driver install on the VM or machine before installing Integrated runtime ? ADF DB2 connector is built on top of Microsoft OLE DB Provider for DB2. ADF copies all DLLs include dependencies during installation of Integration runtime. If you already have OLEDB driver on the VM then dependent DLL required by ADF wont be copied.

If you already had OLEDB driver then uninstall it and Integration runtime and then reinstall Integration runtime.

Share via

Failed to connect to the database. DB2 -Azure data factory

1 additional answer

Your answer