Article View: borland.public.cppbuilder.database.multi-tier
Article #621Re: how to find out a lost communication between client & server
From: Jerri Chiu
Date: Fri, 11 May 2001 21:39
Date: Fri, 11 May 2001 21:39
47 lines
2199 bytes
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!dnewsReferences:
<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