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.

Did you guys forget about me?/SQL Anywhere Error 08S01

2 posts in General Discussion Last posting was on 2005-03-30 13:38:10.0Z
Ron Posted on 2005-03-29 21:21:39.0Z
Sender: 24e3.4240a483.1804289383@sybase.com
From: Ron
Newsgroups: ianywhere.public.general
Subject: Did you guys forget about me?/SQL Anywhere Error 08S01
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4249c6e3.4e5f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Mar 2005 13:21:39 -0800
X-Trace: forums-1-dub 1112131299 10.22.241.41 (29 Mar 2005 13:21:39 -0800)
X-Original-Trace: 29 Mar 2005 13:21:39 -0800, 10.22.241.41
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4309
Article PK: 8126

Thank you for your response. Yes, I am running the latest
available build, 7.0.4 which was distributed Feb 9. What do
you think the problem is?

> > Are you running ASA 7.0.4? Earlier maintenance releases
> > are not supported on Win2003. See
> >
>
http://www.ianywhere.com/products/supported_platforms.html.
> >
> >
> >
> > <Ron> wrote in message
> > news:423f209f.7e18.1681692777@sybase.com... >I have SQL
> > > anywhere Studio Version 7 running on a 2003 Server.
> > > When I attempt to run my front end software and
> > > connect to my
> > > database I receive this error: "SQL State=08S01
> > > [sybase][odbc
> > > driver][adaptive server anywhere] Communication Link
> > > Error: Communication Error"
> > > and the next error message is: "SQL state=S1000
> > > [sybase][odbc
> > > driver][adaptive server anywhere] General
> > > Error:Connection Terminated
> > >
> > > Also, I retrieved a connection log from my frontend
> > > software package and it logged this: "The number of
> > > prefetch rows has been reduced to 41 due to the
> > > prefetch buffer limit. Consider using the
> > PrefetchBuffer connection parameter." >
> > > Has anyone seen this before and if so how did you fix
> > it? >
> > > Thanks,
> > >
> > > Ron


Chris Keating (iAnywhere Solutions) Posted on 2005-03-30 13:38:10.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <4249c6e3.4e5f.1681692777@sybase.com>
Subject: Re: Did you guys forget about me?/SQL Anywhere Error 08S01
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <424aabc2$1@forums-1-dub>
Date: 30 Mar 2005 05:38:10 -0800
X-Trace: forums-1-dub 1112189890 10.25.98.199 (30 Mar 2005 05:38:10 -0800)
X-Original-Trace: 30 Mar 2005 05:38:10 -0800, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4311
Article PK: 8132

Have you tried increasing the "PrefetchBuffer connection parameter" as
recommended?

<Ron> wrote in message news:4249c6e3.4e5f.1681692777@sybase.com...
> Thank you for your response. Yes, I am running the latest
> available build, 7.0.4 which was distributed Feb 9. What do
> you think the problem is?
>
>
>> > Are you running ASA 7.0.4? Earlier maintenance releases
>> > are not supported on Win2003. See
>> >
>>
> http://www.ianywhere.com/products/supported_platforms.html.
>> >
>> >
>> >
>> > <Ron> wrote in message
>> > news:423f209f.7e18.1681692777@sybase.com... >I have SQL
>> > > anywhere Studio Version 7 running on a 2003 Server.
>> > > When I attempt to run my front end software and
>> > > connect to my
>> > > database I receive this error: "SQL State=08S01
>> > > [sybase][odbc
>> > > driver][adaptive server anywhere] Communication Link
>> > > Error: Communication Error"
>> > > and the next error message is: "SQL state=S1000
>> > > [sybase][odbc
>> > > driver][adaptive server anywhere] General
>> > > Error:Connection Terminated
>> > >
>> > > Also, I retrieved a connection log from my frontend
>> > > software package and it logged this: "The number of
>> > > prefetch rows has been reduced to 41 due to the
>> > > prefetch buffer limit. Consider using the
>> > PrefetchBuffer connection parameter." >
>> > > Has anyone seen this before and if so how did you fix
>> > it? >
>> > > Thanks,
>> > >
>> > > Ron