troubleshooting Question

Trying to install Oracle Data Access Components (ODAC)

Avatar of Rita Byrne
Rita ByrneFlag for Ireland asked on
Oracle Database
10 Comments2 Solutions639 ViewsLast Modified:
I am trying to get SQL to talk to an Oracle Database.
Have installed the Oracle Client 11g 32-bit.
Am now trying to install ODAC.

Should they be installed to the same location or is there a particular location ODAC should be installed to?
Client is in C:\Oracle & Name is 'OraClient11g_home1'. The installer complains if I specify the same location & gives the option to go ahead but then fails.

Also, should the oraOLDDB.oracle provider be visible in SQL once this has been done?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros