An application using COM API fails with "provider cannot be found" error
Symptoms
A custom application that uses the COM API is failing on a server where neither Changepoint nor the API is installed, but the custom application is using COM API DLL files for accessing Changepoint.
Error in event log:
Source: ADODB.Connection
Version: 18.1.79.0
Error Number: 3706
Description: Provider cannot be found. It may not be properly installed.
Error in COM API log:
4:26:58 PM Level1: Source: Changepoint.ChangepointAPI2.ApiConnection.validatePassword
4:26:58 PM Level2: Error: Number= -1 Message= Operation failed (system error).
4:26:58 PM Level2: StackTrace: at Changepoint.LegacyInterface.COMUtils.RaiseErrorToEventLog(Boolean bRaiseErrorToClient)
at Changepoint.LegacyInterface.COMUtils.MainExecute(Object oDBConnection, String sConnection, Boolean bMTS, String sSQL, Object[] avParam)
at Changepoint.LegacyInterface.Resource.Resource.checkPasswordVerificationAtLogin(String msConnectionString, String sLoginType, String UserId, String LoginPassword, Int32& iReturn)
at Changepoint.ChangepointAPI2.ApiConnection.validatePassword(ApiUser dbUser)
4:26:58 PM Level1: Log for this source is end.
Reason
SQL Native Client is missing from the environment where COM API DLL files are being used.
Resolution
Install SQL Native Client on the server.