Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Run-time error '3706': Provider cannot be found. It may not be properly installed

3668822Mar 8 2018 — edited Mar 9 2018

Hi,

I am trying to connect to oracle using MSAccess VBA code. I defined the following string:

"Provider=OraOLEDB.Oracle;User id=????;Password=???;Data Source=????"

when I run the code, here is the error i get:

Run-time error '3706': Provider cannot be found. It may not be properly installed.

Just as a note that I am able to run the code using other drivers such as "Driver={Microsoft ODBC for Oracle};Server=????;Uid=???;Pwd=???" but i want to figure what is the problem with the other provider.

currently, Oracle Client 11.2 is running on my machine.

Any though?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2018

Added on Mar 8 2018

#general-database-discussions

5 comments

12,315 views