I don't have any asynchronous feedback mechanism via the InterBase client to
monitor the status of the network connection. This would be a nice feature
to add.

Is all you can do is call VerifyConnection (which really only makes sense
when a connection to the database was obtained and a connection handle is
being held on the client.

Jason Wharton
www.ibobjects.com

-----Original Message-----
From: rodbracher [mailto:rod@...]
Sent: Thursday, June 03, 2004 7:17 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Crazy IBODataset states


Hi
below are accurate reported states of my TIBODatabase connection
status using ConnectinStatus and VerifyConnection. I am finding it
impossible to tell if my database is actually connected by means of a
status. Is running an arbitary query the best way to check your
database is connected? If result do you do `real' stuff otherwise
(on isc error on query) assume the database is not connected? If I
did get an error do I try and connect the database again AND run the
arbitary query again?

TIBODataset = DB

DB.ConnectionStatus = DB_CS

DB.VerifyConnection = DB_VC

I start the app (DB.Connected = false)

DB_CS = csDisconnected
DB_VC = True (Connected)

I then go DB.Connected := true;

DB_CS = csConnected
DB_VC = True

I now pull out the newtowrk cable on my PC

DB_CS = csConnected
DB_VC = False

I run a query – query returns error – the above status is the same.

I plug my network cable back in – above status the same

I run a query – same error (could not connected to host) – above
status the same.

I ForceDisconnect

DB_CS = csDisconnected
DB_VC = True !!!!

I DB.Connect = true

DB_CS = csConnected
DB_VC = True

OK –if you think at this point things are a little unpredictable

Now DB.ForceDisconnecct

DB_CS = csDisconnected
DB_VC = True

Now pull out the network cable

DB_CS = csDisconnected
DB_VC = True

The EXACT opposite staus situation the last time I had no network
connection.