Skip to Main Content

DevOps, CI/CD and Automation

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!

Oracle 12c connectivity from Office 365

b7c5a2e2-62ce-4fad-9137-6098108e8139Apr 10 2018 — edited May 10 2018

I have windows 10, Oracle 12c, and Office 365 installed on my machine. When I try to connect to an oracle database from excel, I get an error of the recommend provider (oracle.dataaccess.client) is not installed. I can connect to Oracle using TOAD with no problem. I've created the 64 bit ODBC data source to the database and the connection tests as okay. Originally the IT group installed 11g and there were issues with it so now I have 12c.  When I run vb code in a spreadsheet that from someone else, I get a very similar error about no installation.  Within the vb module, I've tried every configuration I can't find in the connectionstring to connect with no luck.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2018
Added on Apr 10 2018
1 comment
1,931 views