Try reconfigure CONNECT_TIMEOUT in LISTENER.ORA file to be 0, which means
wait indefinitely.
If it hang forever, you should check for others errors.

regards

Ofer Harel
DBA team
Barak ITC
[Email Address Removed] Message-----
From: Almyeed [mailto:[Email Address Removed] Thursday, November 27, 2003 1:01 PM
To: LazyDBA.com Discussion
Subject: Oracle ODBC Error [Very Urgent !!!!!] posting again...



> Hi All,
>
> Iam having an Oracle 8.1.7 client installed on Win2000 prfessional
> machine. I have TNSname configured to the server and an ODBC created, when
i
> try to test the odbc connection i get this error
>
>
> SQLSTATE:S1000
> Nativer errorcode:12535
> Driver Message:[Oracle][ODBC][ORA]ORA-12535:TNS:operation timed out
>
>
> WHat could be possible solution for this
>
> Thanks in advance
>
> Almyeed
>
> _________________________________________________________________
> The Great MSN Sale. Get shopping discounts. http://www.msn.co.in/Shopping
> Win exciting prizes!
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html


**********************************************************************
The information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent those of
Barak I.T.C (1995) The International Telecommunications Services Corp. Ltd.
**********************************************************************

Oracle LazyDBA home page