>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 ?

Did you put TNSNAMES.ORA where it could be found?
X:\oracle\ora81\network\ADMIN




# TNSNAMES.ORA Network Configuration File: X:\orant\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

WEBSRVR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcltest)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orc1)
)
)

TESTBOX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orcl2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orc2)
)
)

####################################
# Date..........: Wed Dec 19 11:47:20 CST 2001
####################################

ORC9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orc9)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc9)
)
)

ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orclndr)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)

ORC2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orc2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orc2)
(SERVER = DEDICATED)
)
)

ORC1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = orc1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc1)
)
)