Re: No more SID in Oracle 8i?

Don't know how much of a difference it'll make with the pro*c, but try SERVICE_NAME =
where you've got
SID = Kevin

In article <8b8flo$ka8$1_at_news-int.gatech.edu>, kirk_at_kaybee.org wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 01:59:05 CST