I installed Personal Oracle 9i on by Compaq Athlon 4 machine using XP. I am able to connect to the database using SQL*PLUS but unable to do so through ODBC. I keep getting the following error message:
"Unable to Connect
SQL state=S1000
ORA-12535: TNS:Operation timed out"

I have tried both the "Microsoft ODBC for Oracle" and the "Oracle in OraHome92" drivers listed in the ODBC Data Source Administrator.

I also get the following from the Oracle Net Manager :

"initializing first test to use userid: scott, password: tiger
Attempting to connect using userid: scott
The test did not succeed.
ORA-12535: TNS:operation timed out

There may be an error in the fields entered,
or the server may not be ready for a connection. "


Can anyone help ?