Share this article
Improve this guide
Runtime Error 3706: Provider Cannot be Found [Fix]
Quick and surefire solutions to get rid of this error
2 min. read
Updated onOctober 4, 2023
updated onOctober 4, 2023
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
The runtime error 3706 occurs when users try to run some codes using VBA. This frustrating error can be due to minor issues with your code when referencing a provider.
If you are also dealing with this issue, this guide will show you how to fix it, just like we did with theruntime error 438.
Why am I getting the runtime error 3706?
The major cause of this error is if some of the details in your code are incorrect. An example is if you provided the wrong OLEDB version in your code.
So, majorly, this error is usually down to minor issues with your code and can be fixed by making the little changes required.
How can I fix the runtime error 3706?
1. Ensure the details are correct
The only solution to this issue is to make sure the details provided in your code are correct and updated.
For example, you might need to confirm the version of your MS Office on which the script is running if you are using the latest versions of Microsoft Office.
What’s more, you might need to change the OLEDB version from 12.0 to 16.0 if you are using the latest versions of Excel, like 2019.
Another thing to note is that you need to make sure your Version, driver type, and Extended Properties are correct. An example is the code shown in the image below that gave this error asreported by a user on Stack Overflow:
The solution to this was just to change the Version to 12, the driver to ACE from Jet, the Extended Properties to Excel 12.0, and some other minor changes made to the code, as shown below:
So, these little parameters are important to eliminate this runtime error 3706.
2. Use the latest version of Oracle
Sometimes, this runtime error 3706 can be due to an outdated Oracle client version. You need to check with your client to confirm the version and get the latest one available to prevent issues.
We can now conclude this guide on how to fix this runtime error for good on VBA. This issue is majorly down to minor issues with the details provided in your code.
Correcting these details accordingly should solve this effortlessly. If you are dealing with another issue likeruntime error 3709, check our detailed guide to fix it.
Feel free to let us know in the comments below if you could solve this problem.
More about the topics:Microsoft Excel
Ola-Hassan Bolaji
Windows Hardware Expert
A Computer Engineering graduate, he has spent most of his life reading and writing about computers.
He finds joy in simplifying complex topics into simple solutions for PC users. The quality of his work and providing step-wise tested and proven solutions to PC issues are all that matter to him.
Away from computers, he is either reading or watching football!
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Ola-Hassan Bolaji
Windows Hardware Expert
He’s a Computer Engineering graduate who has spent most of his life reading and writing about computers & operating systems.
