Article View: alt.comp.databases
Article #148Re: Communication link failure...
From: Jerry Gitomer
Date: Fri, 02 Apr 2004 20:37
Date: Fri, 02 Apr 2004 20:37
22 lines
2316 bytes
2316 bytes
On Fri, 02 Apr 2004 16:31:41 +0200, Pavel Vetesnik wrote: > Hello, > We are the authors of an application written in PowerBuilder (type > Client-Server, database MSSQLServer2000). After some time (1 hour) of > client inactivity happens disconnect from server and aplication reports > error 'Communication link failure ...' > > Please, would you help me, if exists some way how to set up an interval of > the connectivity between Client and Server. I wasn�t able to find it out > in any help or manual. > > Thank you very much in advance! > Pavel You should add code to your application to capture the login dialogue and log back on to the server in the event the server has dropped the session and the SAME client session wishes to communicate with the server. I suggest this because the timeout value used by the server could change from release to release or be changed by the network/system administrators if resource usage gets too high.
Technical Details
Message-ID:
<pan.2004.04.02.20.37.02.781316@erols.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed2.telusplanet.net!newsfeed.telus.net!bigfeed.bellsouth.net!news.bellsouth.net!peer01.cox.net!cox.net!feed2.news.rcn.net!rcn!feed3.news.rcn.net!not-for-mailReferences:
<c4jtgd$u9a$1@ns.felk.cvut.cz>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: ff490,498aa07099321ba6 X-Google-Attributes: gidff490,public X-Google-Thread: fc5c9,498aa07099321ba6 X-Google-Attributes: gidfc5c9,public X-Google-Thread: 104de1,498aa07099321ba6 X-Google-Attributes: gid104de1,public X-Google-Thread: f5691,498aa07099321ba6 X-Google-Attributes: gidf5691,public X-Google-Thread: 10a90d,498aa07099321ba6 X-Google-Attributes: gid10a90d,public X-Google-ArrivalTime: 2004-04-02 12:36:59 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newsfeed2.telusplanet.net!newsfeed.telus.net!bigfeed.bellsouth.net!news.bellsouth.net!peer01.cox.net!cox.net!feed2.news.rcn.net!rcn!feed3.news.rcn.net!not-for-mail From: Jerry Gitomer <jgitomer@erols.com> Subject: Re: Communication link failure... Date: Fri, 02 Apr 2004 15:37:21 -0500 User-Agent: Pan/0.14.2.91 (As She Crawled Across the Table) Message-ID: <pan.2004.04.02.20.37.02.781316@erols.com> Newsgroups: alt.comp.databases,comp.databases,comp.databases.ms-sqlserver,cz.comp.databases.misc,cz.comp.microsoft.sql References: <c4jtgd$u9a$1@ns.felk.cvut.cz> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 22 X-Trace: DXC=4IRZ04^DMaRHF=LJHb:VjW0R]m=BkYWIW:6bU3OT9S9ZlMfG[HKPl`Z?FFGMNc]l>TRZYSbmSE1CQ X-Complaints-To: abuse@rcn.com