Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

An application using COM API fails with "provider cannot be found" error

  1. Last updated
  2. Save as PDF

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.