ODBC Error "ora-12545 connection failed ...
679330Jan 12 2009 — edited Mar 9 2009Hi All,
Thanks for your assistance. I am trying to set up an ODBC connection to a Oracle database from a MS Server 2000 machine with SQL Server 2000 on it. My goal is to link the Oracle database to the SQL server. For some reason I can not get the ODBC connection to work! I've checked the connection information and it is correct, I'm getting the following error "ora-12545 connection failed because target host or object does not exist" I can ping the host and a get a response. I tested the connection on my XP workstation and the ODBC connection and SQL+ work with no problems. One difference I found in the Oracle Net Manager is the Server 2000 machine has a Oracle Advanced Security option along with Naming and General. My workstation does not have the Oracle Advanced Security option.
Does anyone out there know what I can do to get my connection working?
Thank you for your help.
Arden