DLO Agent failing to connect to the DLO Server with "Unspecified Error"

book

Article ID: 100066458

calendar_today

Updated On:

Description

Error Message

It throws the below error message in the DLOClient.Log file.

04/04/24, 07:58:28:833, dloclientu.exe, 15056:,  >, adoutil.h( 76 ), Connection error: 80004005( 0000001B ) : Registry information is corrupt or missing. Make sure the provider is installed and registered correctly.

04/04/24, 07:58:28:833, dloclientu.exe, 15056:, E>, ADODB.cpp( 622 ), failed opening connection: ADODBError-_com_error: foundationerror=80004005; comerr=80004005; nativeerror=27; conn=Provider=MSOLEDBSQL;Initial Catalog=DLO;Integrated Security=SSPI;Net=xxxxxx;Address=\\DLOServername\pipe\MSSQL$DLO\sql\query;Connect Timeout=20; query=, msg=Unspecified error; src=Microsoft OLE DB Driver for SQL Server, desc=Registry information is corrupt or missing. Make sure the provider is installed and registered correctly.

Cause

This could happen if the MS OLE DB Driver Provider for Microsoft SQL Server is not properly installed due to some restriction through Group Policy or Permission in the Registry.

Resolution

  • From the Add/Remove programs, make sure Microsoft OLE DB Driver for SQL Server is installed.
  • If it's not installed, use the DLOAgent folder from the DLO Server and from the msoledb folder execute the installation using the appropriate .msi file.
  • Check the below registry location and make sure corresponding subkeys are present as stated below:

                                 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI18.0]

                                 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\MSSQLServer\Client\SNI18.0]

  • If the registry keys are missing, import them from the working machine.

 

Issue/Introduction

When a DLO Agent is launched at the client machine it fails to connect to the DLO Server and it gives an error message "Failed to Load Configuration Settings. Unspecified Error"