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?