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 Problem

3 posts in General Discussion (old) Last posting was on 2000-03-24 16:48:31.0Z
Steve Zehm Posted on 2000-03-23 17:24:20.0Z
Newsgroups: sybase.public.easerver
From: "Steve Zehm" <steven_c_zehm@rl.gov>
Subject: Oracle Connection Cache Problem
Date: Thu, 23 Mar 2000 09:24:20 -0800
Lines: 24
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_cBhRi1Ol$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25816
Article PK: 155858

I am still having trouble successfully pinging an OCI 7.x connection cache.
I can connect to my database through SQL NET, and I can ping it using an
ODBC connection cache, but when I try to ping it using the OCI 7.x setting,
I get the following error: "Ping Failed, Could not find the specified
connection cache." Here are my settings:

Server Name: hditest --- I can ping this database using tnsping80
from a dos prompt
DLL: ociw32.dll
Setting: OCI 7X

Is there anything special I need to install or set before I can use the OCI
7X setting?? I have also tried to ping an 8.05 database using OCI 8x and
oci.dll, but no luck.

Thanks,

Steve Zehm
SR. Software Eng.
Lockheed Martin Services Inc.
Richland, WA


Bill Green[TeamSybase] Posted on 2000-03-24 16:48:31.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 24 Mar 2000 11:48:31 -0500
From: "Bill Green[TeamSybase]" <bill.green@teamsybase.com>
Reply-To: bill.green@teamsybase.com
Organization: TeamSybase
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Oracle Connection Cache Problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 37
NNTP-Posting-Host: threshold3.jpmorgan.com 169.71.1.12
Message-ID: <347_38DB9C5F.C69DA333@teamsybase.com>
References: <347_cBhRi1Ol$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25742
Article PK: 155791

To add to Jim's suggestions, I have found that a userid/password is required in
the connection caches. Try adding that too.

HTH,
Bill

Steve Zehm wrote:

> I am still having trouble successfully pinging an OCI 7.x connection cache.
> I can connect to my database through SQL NET, and I can ping it using an
> ODBC connection cache, but when I try to ping it using the OCI 7.x setting,
> I get the following error: "Ping Failed, Could not find the specified
> connection cache." Here are my settings:
>
> Server Name: hditest --- I can ping this database using tnsping80
> from a dos prompt
> DLL: ociw32.dll
> Setting: OCI 7X
>
> Is there anything special I need to install or set before I can use the OCI
> 7X setting?? I have also tried to ping an 8.05 database using OCI 8x and
> oci.dll, but no luck.
>
> Thanks,
>
> Steve Zehm
> SR. Software Eng.
> Lockheed Martin Services Inc.
> Richland, WA

--
Bill Green[TeamSybase]

-----------------------------------------------------------
Good Links to know, good places to go:

Sybase Developer Network (SDN) - http://www.sybase.com/sdn
Find things like:
-- Print to PDF component
-- Lotus Notes E-Mail component
-- Taking existing PB apps to the web white paper

PFC Guide - http://www.pfcguide.com
Power3 - Custom Training - http://www.power3.com
-----------------------------------------------------------


Jim O'Neil [Sybase] Posted on 2000-03-23 19:19:59.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 23 Mar 2000 14:19:59 -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 Problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 30
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38DA6E5E.E7CB1C4D@sybase.com>
References: <347_cBhRi1Ol$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25805
Article PK: 155845


Steve Zehm wrote:

> I am still having trouble successfully pinging an OCI 7.x connection cache.
> I can connect to my database through SQL NET, and I can ping it using an
> ODBC connection cache, but when I try to ping it using the OCI 7.x setting,
> I get the following error: "Ping Failed, Could not find the specified
> connection cache." Here are my settings:
>
> Server Name: hditest --- I can ping this database using tnsping80
> from a dos prompt
> DLL: ociw32.dll
> Setting: OCI 7X
>
> Is there anything special I need to install or set before I can use the OCI
> 7X setting?? I have also tried to ping an 8.05 database using OCI 8x and
> oci.dll, but no luck.
>
> Thanks,
>
> Steve Zehm
> SR. Software Eng.
> Lockheed Martin Services Inc.
> Richland, WA

Confirm that the cache is actually installed in a Jaguar server, you can't ping
a cache (well, usually) that's in the Connection Caches folder UNLESS it's been
installed in a specific server. Also, make sure you press the refresh button
before trying to Ping the cache.


--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc