Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Oracle connection cache

3 posts in General Discussion (old) Last posting was on 2000-03-22 21:16:30.0Z
Steve Zehm Posted on 2000-03-22 19:15:46.0Z
Newsgroups: sybase.public.easerver
From: "Steve Zehm" <steven_c_zehm@rl.gov>
Subject: Oracle connection cache
Date: Wed, 22 Mar 2000 11:15:46 -0800
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: dagate.rl.gov 130.97.128.13
Message-ID: <347_fiRLJPDl$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25904
Article PK: 154359

I am having trouble setting up my connection cache for oracle 7.3. I can
ping my database from sqlplus any suggestions?

Here are my connection cache settings:

Servername: @tns:hdidevl
Driver: oci7.x
file: ociw32.dll


Hitesh Patel Posted on 2000-03-22 20:52:53.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 15:52:53 -0500
From: Hitesh Patel <hpatel@cbsinc.com>
Organization: CBSI
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Oracle connection cache
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 9
NNTP-Posting-Host: 162.108.32.25
Message-ID: <347_38D932A5.28795B59@cbsinc.com>
References: <347_fiRLJPDl$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25892
Article PK: 155926

Remove the @ sign in Servername

Thanks
Hitesh

Steve Zehm wrote:

> I am having trouble setting up my connection cache for oracle 7.3. I can
> ping my database from sqlplus any suggestions?
>
> Here are my connection cache settings:
>
> Servername: @tns:hdidevl
> Driver: oci7.x
> file: ociw32.dll


Jim O'Neil [Sybase] Posted on 2000-03-22 21:16:30.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 16:16:30 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Oracle connection cache
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 13
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38D9382E.F48C81DB@sybase.com>
References: <347_fiRLJPDl$GA.202@forums.sybase.com> <347_38D932A5.28795B59@cbsinc.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25884
Article PK: 155919


Hitesh Patel wrote:

> Remove the @ sign in Servername
>
> Thanks
> Hitesh
>
> Steve Zehm wrote:
>
> > I am having trouble setting up my connection cache for oracle 7.3. I can
> > ping my database from sqlplus any suggestions?
> >
> > Here are my connection cache settings:
> >
> > Servername: @tns:hdidevl
> > Driver: oci7.x
> > file: ociw32.dll

... and the tns:
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc