-
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
-
firewalls?
cant resolve hostname?
dodgy tnsnames.ora?
try to connect from sqlplus, see if that works
-
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"
-
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.
-
how much time it takes to ping hostname and tnsping service name?
"What is past is PROLOGUE"
-
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
-
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
-
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
-
there was a mistake in my previous post, should be telnet hostname 1521
where hostname is the name of your server obviously
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|