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.

ASA 8.0.2, Delphi 7 and Prefetchbuffer problem and Windows 2003

2 posts in General Discussion Last posting was on 2003-11-03 10:44:14.0Z
Eric Posted on 2003-10-31 18:41:44.0Z
From: "Eric" <ericr@trans-soft.net>
Newsgroups: ianywhere.public.general
Subject: ASA 8.0.2, Delphi 7 and Prefetchbuffer problem and Windows 2003
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: ip68-2-57-49.ph.ph.cox.net
Message-ID: <3fa2ae05$1@forums-2-dub>
X-Original-Trace: 31 Oct 2003 10:46:29 -0800, ip68-2-57-49.ph.ph.cox.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 31 Oct 2003 10:33:54 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 31 Oct 2003 10:41:44 -0800
X-Trace: forums-1-dub 1067625704 10.22.108.75 (31 Oct 2003 10:41:44 -0800)
X-Original-Trace: 31 Oct 2003 10:41:44 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1985
Article PK: 4208

Hi -

We've recently added the Delphi 7 object of TStoredProc to our application.
When running on a Window 2003 machine we now get an error:

10:26:48 [1224618278] The number of prefetch rows has been reduced to 94 due
to the prefetch buffer
10:26:48 [1224618278] limit. Consider using the PrefetchBuffer connection
parameter.

It isn't happening on clients running XP, just 2003. We tried to set PBUF
and PROWS to larger numbers but we're not sure how to adjust to fit. We've
picked some larger buffers and rows, we see the error message change to 300
row ( reduced to ) but nothing ran clean.

Two questions:
1) How do you determine a good number for PBUF and PROWS
2) What happened ?? ;-)


Serge Gavrilov Posted on 2003-11-03 10:44:14.0Z
Message-ID: <3FA62F93.9090803@mail.ru>
From: Serge Gavrilov <sergegavrilov@mail.ru>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA 8.0.2, Delphi 7 and Prefetchbuffer problem and Windows 2003
References: <3fa2ae05$1@forums-2-dub>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: ip204178.seaport.spb.ru
X-Original-Trace: 3 Nov 2003 02:49:07 -0800, ip204178.seaport.spb.ru
Lines: 5
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Nov 2003 02:36:07 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Nov 2003 02:44:14 -0800
X-Trace: forums-1-dub 1067856254 10.22.108.75 (3 Nov 2003 02:44:14 -0800)
X-Original-Trace: 3 Nov 2003 02:44:14 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1995
Article PK: 4221

Try SaVcl.
http://savcl.narod.ru/en.html

Best regards, Serge Gavrilov.