I have seen various flavors of this discussion, but am not able to solve my specific problem.
- I am running 64-bit Windows 7 Professional.
- I have Office 32-bit.
- I have both 64-bit Oracle 12, and 32-bit 11g client installed
- My path is
C:\app\**\product\32bit\11.2.0\client_1;C:\app\**\product\12.1.0\dbhome_2\bin;
- I do not have an ORACLE_HOME or TNS_ADMIN variable configured
Now I want to connect Excel to a remote data
base. In the Excel ribbon Data -> Connections, there is a connection of type 'OLE DB Query', with a Connection string
Provider=MSDAORA.1;User ID=**;Data Source=[Host]:1521:[SID];Password=[**]
There is no other database configuration. How can I tell it to connect to the 32bit client? Now when I run this, I get
'ORA-12545: Connect failed because target host or object does not exist'
(I am able to connect to the database using SQLDeveloper)
So next, I modify the 'Connection Properties' - > 'Connection string' to
Provider=MSDAORA.1;User ID=**;Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = [Host])
(PORT = 1521)
)
(CONNECT_DATA = (SID = [SID])
(SERVER = DEDICATED)
)
)
'ORA-12154: TNS: could not resolve the connect identifier specified'
Does anyone know how to fix this please?