Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Posts
    2

    Unanswered: Connection problem

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Does listener.log file provide any clue that the request from MS Server 2000 is ever getting to the Oracle server?

    The real question is where is the request "getting lost" or how far is it going?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2009
    Posts
    2
    Hi Anacedent,

    Thank you for your reply. Does the listener.log reside on the Oracle DB box? If it does there is No Way I can get to it. Your statement "The real question is where is the request "getting lost" or how far is it going?" is exactly what i need to find out.

    I'm thinking it is a MS Server 2000 issue, not an Oracle issue because the XP workstations can connect with no problems.

    Thanks again for your help,
    Arden

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Does the listener.log reside on the Oracle DB box?
    Yes, the listener.log file resides on DB server system.

    If you get desperate, you could try "sniffing" the network using Ethereal
    or similar s/w to see the contents of packets be exchanged.

    I can't be of further assistance debugging on Windows side.

    Good Luck!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    Can you post the contents of the sqlnet.ora and tnsnames.ora files from both the server that can't connect and from a workstation that can connect?

    I can't recall ever receiving an ORA-12545 error that wasn't a configuration problem somewhere in the stack. So let's start at the most liekly place, the Oracle client config files.

    Also, have you tried SQL*Plus or tnsping from the server?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •