Test connection alive

Thread View: borland.public.cppbuilder.database.dbexpress

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by yartax Thu, 19 Aug 2004 16:24

#96

Author: yartax
Date: Thu, 19 Aug 2004 16:24

12 lines
1256 bytes

Hi everyone,


How can I test if a Interbase connection is alive and reconnect if
necessary? I make a BCB6 program to work with Interbase/Firebird servers.
This program (client side app) uses ADSL to connect to servers, and
connection can be lost at any moment. My idea is to put a TTimer component
and test TIBDatabase->Active property every minute to check out, but doesn't
works Also tried to use a TIBEvents but I don't know how configure it.


Thanks!

Re: Test connection alive

#110

Author: Jason Chapman
Date: Sun, 17 Oct 2004 16:42

29 lines
1965 bytes

Until you try and do something the DB component will not realise that 
anything has gone wrong.  You would have to do something to the connection, 
e.g. have a query running every few minutes with select cast('now' as Date) 
from rdb$database.  You would then get an exception when the connection went 
down and you could disconnect and reconnect.

Anyway - I would be concerned about not encrypting traffic over the 
internet.

JAC.


<yartax@hotmail.com> wrote in message 
news:4124d43c$1@newsgroups.borland.com...
> Hi everyone,
>
>
> How can I test if a Interbase connection is alive and reconnect if
> necessary? I make a BCB6 program to work with Interbase/Firebird servers.
> This program (client side app) uses ADSL to connect to servers, and
> connection can be lost at any moment. My idea is to put a TTimer component
> and test TIBDatabase->Active property every minute to check out, but 
> doesn't
> works Also tried to use a TIBEvents but I don't know how configure it.
>
>
> Thanks!
>
>

SQL State:08001, SQL Error Code:17

#140

Author: hhq
Date: Sun, 27 Mar 2005 04:53

13 lines
1094 bytes

Hi Jason Chapman,

When I use MTS(dbx) link to MSSQL2000 , I get a
ERROR:

SQL State:08001, SQL Error Code:17

[DBNETLIB][ConnecttionOpen(Connect().) SQL Server

Please help me!!!

>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads