🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #621

Re: how to find out a lost communication between client & server

#621
From: Jerri Chiu
Date: Fri, 11 May 2001 21:39
47 lines
2199 bytes
Hi Mark!

thanks much...! that really helped, i just need to find out what is the
time-out message.  I couldn't find it from the C++ builder help file.

does anybody has any idea?  has anybody used it before?

Thanks much again!
Jerri Chiu


"Mark Cashman" <mcashman@temporaldoorway.com> wrote in message
news:3AF89C5C.3570E6D0@temporaldoorway.com...
> Hi, Jerri!
>
> SQL Server times out in that situation; I imagine your query would.
> So...
>
>     try
>     {
>         Query1->Open();
>     }
>     catch (EDatabaseError &DatabaseError)
>     {
>         if (TimeOutMessage(DatabaseError.Message))
>         {
>             ReconnectDatabase();
>         };
>     };
>
> Obviously you have to figure out what message is a timeout message and
> you have to test whether reconnecting to the database in that state is
> safe.
>
> I hope this helps.
>
> --
> ------
> Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
> http://www.temporaldoorway.com
> - Original digital art, writing, music and more -
> C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
> (Join us!)
> http://www.temporaldoorway.com/programming/index.htm
> ------
>
>
Technical Details
Message-ID: <3afc5c95$1_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.sj.google.com!newsfeed.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews
References: <3af710e3_1@dnews> <3AF89C5C.3570E6D0@temporaldoorway.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,ce83157180cad44b
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-05-11 15:18:01 PST
From: "Jerri Chiu" <jeje@home.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
References: <3af710e3_1@dnews> <3AF89C5C.3570E6D0@temporaldoorway.com>
Subject: Re: how to find out a lost communication between client & server
Date: Fri, 11 May 2001 14:39:04 -0700
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 130.110.218.101
Message-ID: <3afc5c95$1_1@dnews>
X-Trace: dnews 989617301 130.110.218.101 (11 May 2001 14:41:41 -0700)
Path: arc1-ca.pugleaf.net!archiver1.sj.google.com!newsfeed.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews