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.

connection error to database

2 posts in QAnywhere Last posting was on 2005-03-19 12:53:58.0Z
fox0815 Posted on 2005-03-18 11:24:22.0Z
Sender: 4cc1.423ab88f.1804289383@sybase.com
From: fox0815
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: connection error to database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <423aba66.4cdb.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Mar 2005 03:24:22 -0800
X-Trace: forums-1-dub 1111145062 10.22.241.41 (18 Mar 2005 03:24:22 -0800)
X-Original-Trace: 18 Mar 2005 03:24:22 -0800, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:84
Article PK: 18763

our database program uses sql anywhere. we have one special
computer that is showing error messages for some weeks
regularly. when the program tries to get information from
the server it gives the error message:
DataWindow Error
Select error: SQLSTATE = 08S01
error in the connection

then about 20 times the same message appears
DataWindow Error
Select error: SQLSTATE = S1000
connection was closed

we have no explanation for this error! only one computer is
having this problem.
after all error messages are closed an the program started
again. sometimes everything works fine!

thanx for help
andré


Chris Keating (iAnywhere Solutions) Posted on 2005-03-19 12:53:58.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
References: <423aba66.4cdb.1681692777@sybase.com>
Subject: Re: connection error to database
Lines: 54
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: vpn-dub-058.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-058.sybase.com
Message-ID: <423c20e6$1@forums-1-dub>
Date: 19 Mar 2005 04:53:58 -0800
X-Trace: forums-1-dub 1111236838 10.22.120.58 (19 Mar 2005 04:53:58 -0800)
X-Original-Trace: 19 Mar 2005 04:53:58 -0800, vpn-dub-058.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:85
Article PK: 18764

This is not a qanywhere question, is it? If not, I think that you should
move this question to sybase.public.sqlanywhere.general.

When you repost, please include the version and build of ASA and PB. You
should also look at what is unique about the machine where this problem is
occuring relative to other machines. It could simply be a bad network card.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

*****************************************************************************

<fox0815> wrote in message news:423aba66.4cdb.1681692777@sybase.com...
our database program uses sql anywhere. we have one special
computer that is showing error messages for some weeks
regularly. when the program tries to get information from
the server it gives the error message:
DataWindow Error
Select error: SQLSTATE = 08S01
error in the connection

then about 20 times the same message appears
DataWindow Error
Select error: SQLSTATE = S1000
connection was closed

we have no explanation for this error! only one computer is
having this problem.
after all error messages are closed an the program started
again. sometimes everything works fine!

thanx for help
andré