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.

Negative values in Connection Cache.

2 posts in General Discussion (old) Last posting was on 2000-02-10 21:45:40.0Z
Himanshu Posted on 2000-02-10 18:51:47.0Z
Newsgroups: sybase.public.easerver
From: "Himanshu" <h_v_joshi@hotmail.com>
Organization: 199.228.142.7
X-Newsreader: AspNNTP 1.41 (Advent 2000, Inc.)
Subject: Negative values in Connection Cache.
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Thu, 10 Feb 2000 13:51:47 -0500
Lines: 8
NNTP-Posting-Host: 207.156.232.4
Message-ID: <347_EErzhf$c$GA.96@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28965
Article PK: 161329

Hi!

I am getting negative values in the Runtime monitoring of the Jaguar server.

Also I am getting this error:

com.sybase.jdbc.SybSQLException: SET CHAINED command not allowed within
multi-statement transaction.

All the procedures are in "ANYMODE".

Any clues,
Thanks in advance
Himanshu


Scott McReynolds [Sybase] Posted on 2000-02-10 21:45:40.0Z
Newsgroups: sybase.public.easerver
From: "Scott McReynolds [Sybase]" <scottmc@sybase.com>
Subject: Re: Negative values in Connection Cache.
Date: Thu, 10 Feb 2000 14:45:40 -0700
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: robocop-5-pool80.sybase.com 130.214.144.209
Message-ID: <347_MfIsmCBd$GA.184@forums.sybase.com>
References: <347_EErzhf$c$GA.96@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28941
Article PK: 161307

Himanshu,

I have seen this when the wrong driver type is being used against a
database. For example using the M.S. SQL Server driver against a Sybase
database or visa versa.

How is your SQL Server database setup (CHAINED vs UNCHAINED mode). what ID
are you signing in with on the connection cache?

Scott

Himanshu <h_v_joshi@hotmail.com> wrote in message
news:EErzhf$c$GA.96@forums.sybase.com...
> Hi!
>
> I am getting negative values in the Runtime monitoring of the Jaguar
server.
>
> Also I am getting this error:
>
> com.sybase.jdbc.SybSQLException: SET CHAINED command not allowed within
> multi-statement transaction.
>
> All the procedures are in "ANYMODE".
>
> Any clues,
> Thanks in advance
> Himanshu