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.

Access 2000 with W2000 infinit wait for results

2 posts in General Discussion Last posting was on 2003-09-05 13:31:38.0Z
Ad van Rossum Posted on 2003-09-05 11:39:42.0Z
From: "Ad van Rossum" <Arnoldus66@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: Access 2000 with W2000 infinit wait for results
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: nat-004.azn.nl
Message-ID: <3f587641$1@forums-2-dub>
X-Original-Trace: 5 Sep 2003 04:40:49 -0700, nat-004.azn.nl
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Sep 2003 04:37:07 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Sep 2003 04:39:42 -0700
X-Trace: forums-1-dub 1062761982 10.22.108.75 (5 Sep 2003 04:39:42 -0700)
X-Original-Trace: 5 Sep 2003 04:39:42 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1703
Article PK: 3924

I connect to a database (Adaptive Server Anywhere 6.0.3) with Access 2000.
Depending on the version of Windows I get different responses. With W95
query response is quite fast.

With W2000 queries that access tables, with more then 255 rows, result in an
infinite wait.



Does anyone know a fix for this problem.



Thanks in advance


Nick Elson Posted on 2003-09-05 13:31:38.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <3f587641$1@forums-2-dub>
Subject: Re: Access 2000 with W2000 infinit wait for results
Lines: 42
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
NNTP-Posting-Host: nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <3f58903a$1@forums-1-dub>
Date: 5 Sep 2003 06:31:38 -0700
X-Trace: forums-1-dub 1062768698 172.31.143.50 (5 Sep 2003 06:31:38 -0700)
X-Original-Trace: 5 Sep 2003 06:31:38 -0700, nicelson-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1704
Article PK: 3926

one observation:

Windows 2000 changed some of the rules for a number facilities we use,
so we needed to add a few 'fixes' to the product. MOST of those 'fixes'
were added to 6.0.4 as ebfs. You should try this at an ebf at least as
high as 6.0.4 EBF #3701 since that is where we certified (past tense
intended) 6.0.4. If you look at the 'Archived' certification matrix at

http://www.sybase.com/detail?id=1023009

For 6.0.4 these are the ebfs required for the current Windows releases:

XP (EBF #3763 or higher)
2000 (EBF #3701 or higher)

but that is also the end of the road since 6.0.4 is officially past all
engineering support! [reference: the current certification matrix
http://www.sybase.com/detail?id=1002288 and the EOS notice
http://www.sybase.com/detail?id=1013108 ]

"Ad van Rossum" <Arnoldus66@yahoo.com> wrote in message
news:3f587641$1@forums-2-dub...
> I connect to a database (Adaptive Server Anywhere 6.0.3) with Access 2000.
> Depending on the version of Windows I get different responses. With W95
> query response is quite fast.
>
> With W2000 queries that access tables, with more then 255 rows, result in
an
> infinite wait.
>
>
>
> Does anyone know a fix for this problem.
>
>
>
> Thanks in advance
>
>