Reopening an existing ADO connection in VBA or VB

Last Published: April 25, 2020


Closing and subsequently reopening an ADO connection (in VBA or VB) sometimes fails with the following error:

"Provider not found. It may not be properly installed."


Provider has not been referenced prior to reopening.

Solution or Workaround

Include the following line of code before you reopen the ADO connection:

<ADO connection object>.provider = <name of provider>

Article ID:000002669

  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options