DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: ODBC driver not responding - please help

  1. #1
    Join Date
    Sep 2006
    Posts
    6

    ODBC driver not responding - please help

    Hi,

    This is what I am trying to do.

    I want to connect to a database on another server from my PC using the ODBC driver. So here are the steps I performed.

    1. Installed the Oracle 9i client.
    2. Opened the Net Configuration assistant.
    3. Performed all the steps in the "Net Service Name Configuration"
    4. checked the tnsnames.ora file to see if the correct information was written. (and this checked out ok)
    5. Tested the connection from the "Net Configuration Assistant" itself and connection was successful.
    6. Opened ODBC Data Source Administrator. Created a Data Source Name and tried to test the connection. connection checks out from my machine but when i tried to do the same thing from our group server the screen freezes up and after a while it says "not responding"

    Does anyone know what I might be doing wrong here.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    firewalls?

    cant resolve hostname?

    dodgy tnsnames.ora?

    try to connect from sqlplus, see if that works

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Test the ODBC connection with different users, after confirming the connection through sqlplus.

    Was there any recent group policy changes for your local network that might prevent access?
    "What is past is PROLOGUE"

  4. #4
    Join Date
    Sep 2006
    Posts
    6

    SQL Plus not responding

    Ok so I went to the Oracle submenu and clicked on SQLPLUS and it prompted me for username, password and hostname. I typed all that in and got a familiar response "not responding"... this thing is driving me nuts.

    dbasan: this is a new requirement to run the application on the server so that why i dont know if the access was working before or not or if it has been affected by any recent network changes.

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    how much time it takes to ping hostname and tnsping service name?
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Sep 2006
    Posts
    6
    ping returned back quickly approx round trip time was 12ms

    but tnsping is a different story.. I'm still waiting on it... its been almost 10 minutes

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    do

    telnet 1521 (if the listener is running on port 1521)

    if that port is open, it will say connected to ...

    otherwise it will timeout and you might have a firewall / access rights problem

  8. #8
    Join Date
    Sep 2006
    Posts
    6
    connecting to 1521...Could not open connection to the host, on port 23: Connect failed.

    by the way it does say (PORT = 1521) in tnsnames.ora

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    there was a mistake in my previous post, should be telnet hostname 1521

    where hostname is the name of your server obviously

  10. #10
    Join Date
    Sep 2006
    Posts
    6
    ok so now it says connecting and then i guess it connected because the title of the command prompt window changes to "telnet myhostname" and it has a cursor at the top of the screen.

Posting Permissions

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


Click Here to Expand Forum to Full Width