asked on Trying to install Oracle Data Access Components (ODAC)
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?
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?
Oracle Database
Last Comment
slightwv (䄆 Netminder)
ASKER
Yes, SQL Server.
Install 11g 32-bit Client (Runtime Version).
Install 11g 32-bit Client (Runtime Version).
>>Install 11g 32-bit Client (Runtime Version).
"Runtime Version" doesn't mean anything to me. Can you show me the link where you downloaded it from?
"Runtime Version" doesn't mean anything to me. Can you show me the link where you downloaded it from?
ASKER
I ran the setup.exe for the 11g client.
It gives the option of installing:
InstantClient
Administrator
Runtime
Custom
Screen-shot attached
Oracle-ScreenShot.docx
It gives the option of installing:
InstantClient
Administrator
Runtime
Custom
Screen-shot attached
Oracle-ScreenShot.docx
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the replies. I installed via Custom install but did need to install the 64-bit client in order to get it to work.
Is there any additional information you required to be able to give us an "A" grade?
A "B" grade is a penalty.
A "B" grade is a penalty.
ASKER
My apologies, that was a mistake & I am requesting that the grade be changed to an 'A'.
Thanks.
Which client did you install?
If it was anything other than the Instant Client, the same drivers with the ODAC are avaliable. If you did a Full install, they should be there. If you rerun the installer and chose Custom, they should be visible in the list of items to install.