Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Error "ora-12545 connection failed ...

679330Jan 12 2009 — edited Mar 9 2009
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2009
Added on Jan 12 2009
4 comments
6,812 views