🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #3061

Connectivity Problems using ADOExpress with Sybase ASA 8.0.1

#3061
From: Arun kumar
Date: Wed, 08 Jan 2003 06:54
24 lines
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-mail

Show 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