Article View: borland.public.cppbuilder.database.ado
Article #3061Connectivity Problems using ADOExpress with Sybase ASA 8.0.1
From: Arun kumar
Date: Wed, 08 Jan 2003 06:54
Date: Wed, 08 Jan 2003 06:54
24 lines
1965 bytes
1965 bytes
Hello All,
I am having a connectivity problem using ADOExpress with Sybase Adaptive Server Anywhere 8.0.1.It happens frequently within 2 - 3 minutes of inactivity.I frequently get the following errors
[Sybase][ODBC Driver][Adaptive Server Anywhere]Communication link failure: Communication error
or
[Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Connection was terminated
Our Application was using Sybase SQL Anywhere 6.0 for a long time.Recently we migrated to ASA 8.0, and now we are getting this error.
We use Borland C++ Builder 5.0 with Update 1 Patch applied and
ADOExpress with Update patch applied.
The same application works without any problems in Sybase ASA 6.0
I have logged the connection details both in Sybase Server and
the by enabling debug in ODBC connection.Both the logs say "client Disconnected".
Also is there a problem with using a sigle ADOConnection with
multiple ADOCommands, Datasets etc.
Could this be the cause.
Thanks and Regards
arun kumar
Technical Details
Message-ID:
<3e1bcb3e$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!feedme.news.mediaways.net!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,f6602efe129792f5,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-01-07 23:01:32 PST From: "Arun kumar" <m_arooncoomar@hotmail.com> Sender: "Arun kumar" <m_arooncoomar@hotmail.com> Reply-To: "Arun kumar" <m_arooncoomar@hotmail.com> Subject: Connectivity Problems using ADOExpress with Sybase ASA 8.0.1 Newsgroups: borland.public.cppbuilder.database.ado X-User-Info: 203.200.31.62 203.200.31.62 NNTP-Posting-Host: 207.105.83.65 Message-ID: <3e1bcb3e$1@newsgroups.borland.com> Date: 7 Jan 2003 22:54:54 -0800 X-Trace: newsgroups.borland.com 1042008894 207.105.83.65 (7 Jan 2003 22:54:54 -0800) Lines: 25 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!feedme.news.mediaways.net!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail