PROBLEM
Reopening an existing ADO connection in VBA or VB
Description
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."
Cause
Provider has not been referenced prior to reopening.
Solution or Workaround
Include the following line of code before you reopen the ADO connection:
Code:
<ADO connection object>.provider = <name of provider>
Article ID:000002669
Software:
- ArcMap 8 x
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App