Return
-
Title
Error Upgrading to UCD 8.6.3.180 with Error code -2146824582 "Provider cannot be found" -
Description
When attempting to upgrade UCD to version 8.6.3.180, users may get an error during the first few steps.
Could not connect to SQL Server specified.
Error Code: -2148624582
Message: Unknown error 0x800A0E7A
Source: ADODB.Connection
Error Description: Provider cannot be found. It may not be properly installed. -
Cause
This error is triggered when the server is missing additional drivers to connect to the SQL Server.
UCD version 8.6.3.180 requires the following drivers:- SQL Server Native Client 2012 QFE
- Microsoft OLE DB Driver 18 for SQL Server
- Microsoft OLE DB Driver 19 for SQL Server
-
Resolution
To resolve this issue, please install the following drivers on your UCD server, then rerun the update.
Microsoft SQL Server 2012 Native Client:
https://www.microsoft.com/en-US/download/details.aspx?id=50402
Microsoft OLE DB Driver 18 for SQL Server
https://www.microsoft.com/en-us/download/details.aspx?id=56730
Microsoft OLE DB Driver 19 for SQL Server
https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16