Is Pro*c installed into the same Oracle home as the sqlplus that you are
running. If not it'll be using a different tnsnames.ora.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
<kirk_at_kaybee.org> wrote in message news:8b8flo$ka8$1_at_news-int.gatech.edu...
> Now, the following tnsname.ora seems to work with my machines using
> Oracle 8i (at least it works for sqlplus).
>
> However, if I understand it correctly, the use of the SID is outdated
> with Oracle 8i and maybe things are just running in compatibility mode?
> Maybe this is fine for sqlplus, but maybe this is why my Pro*C program
> is having problems?
>
> Here is my tnsnames.ora:
>
>
> # TNSNAMES.ORA Configuration
File:/mnt/oracle/OraHome/network/admin/tnsnames.ora
> # Generated by Oracle Net8 Assistant
>
> TWEB =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = hidden-hostname)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = TEST2)
> )
> )
>
>
> --
> Kirk Bauer -- CmpE, Georgia Tech -- kirk_at_kaybee.org -- Avid Linux User
> GT Sport Parachuting Club! http://cyberbuzz.gatech.edu/skydive
> Opinions expressed are my own, but they should be everybody's.
Received on Fri Mar 24 2000 - 10:20:11 CST
