URGENT one !!!

[Sunny]

can I access Oracle 8.1.6 database with either 8.0.5 or 7.3 client....

[jee]

You can do it.

Please make an entry in the tnsnames.ora. that's enough.

you can find tnsnames.ora in orant\network\admin folder

bye from jee

[Sunny]

what entry ???

[chobo]

Accessing to ORACLE8.1 with lower version of sqlplus(8.0) throuth SQL*NET(NET8) is not a problem if you put Instance Name in your tnsnames.ora file and your Listner Process is up.
but, with a lower version of Developer, you might not use Higher version of database as I know.

[Sunny]

Can you please tell me exactly which parameter....
i mena weather SID or SERVICE_NAME or something else ...

[chobo]

For this case,
sqlplus system/manager@TEST_DB

(TEST_DB is Service Name is need to be set in the tnsnames.ora)

the following is the example of the tnsnames.ora file.
TEST_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 117.0.8.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = TEST)
)
)

[Sunny]

thats the same I've rightnow ??

[wjramsey]

Post your TNSNAMES.ORA file