The 'DB2OLEDB.1' provider is not registered on the local machine

image-20251116-123103.png

This error can occur if a component on the Endpoint Server is no longer present. It may be seen in the Endpoint Server log file for the Connectors it manages.

This is an example log entry illustrating the issue:

2018-06-16 11:00:40 - INFO: ILMT data sync cycle starting
2018-06-16 11:00:40 - INFO: Connecting to database [XXXXX] on server YYYYYYY port ZZZZZZ
2018-06-16 11:00:40 - ERROR: Failed to connect to the database XXXXX
2019-06-16 11:00:40 - EXCEPTION: The 'DB2OLEDB.1' provider is not registered on the local machine.

This error indicates the Microsoft OLE DB Provider for DB2 is missing from the Endpoint Server. Here’s an example of an Endpoint Server with the component showing via Control Panel:

This Microsoft OLE DB Provider for DB2 is included within the Certero installation and setup routine for an Endpoint Server and is installed by default with the product.

To rectify this issue, you can either:

  • For the default Endpoint Server: re-install Certero Provisioning.

  • For other Endpoint Servers: re-install the Endpoint Server.

  • Or for either Endpoint Server, the Microsoft OLE DB Provider for DB2 can be downloaded from here and installed on the Endpoint Server manually:

https://blogs.msdn.microsoft.com/sjackson/2012/12/31/microsoft-ole-db-provider-for-db2-v4-0-refresh-is-available/