Hello,

I'm working with a vendor who uses your DBISAM database. I'm connecting via your ODBC product through .net 2.x. The vendor tells me that inactivity
will cause the database to timeout, so I can't leave me connection open for long periods. So, I tried to duplicate this so I can see what error message is
thrown. However, I can't seem to make it error!

I can open an ODBC connection, then go to Server Administrator and disconnect the session. Then, I let my app continue, and it somewhow seems to
reconnect! I go back and look iin Server Administrator and the connection is back again.

Does the ODBC driver take care of this somehow or am I not duplicating the test correctly?

Hi,

I monitor the connection via the "StateChange" event, something like the following in C# and .NET 2.0

Init()
{
  Connection.StateChange += new System.Data.StateChangeEventHandler(ConnectionStateChange);
  ConnectionStatusLabel.Text = " Connection : " + Info.Connection.State.ToString();
}

private void ConnectionStateChange(object sender, StateChangeEventArgs e)
{
  ConnectionStatusLabel.Text = " Connection : " + e.CurrentState.ToString();

  if (e.CurrentState == ConnectionState.Closed || e.CurrentState == ConnectionState.Broken)
    ConnectionStatusLabel.BackColor = Color.Red;
  else
    ConnectionStatusLabel.BackColor = SystemColors.ControlLight;
}

Chris Holland
SEC Solutions Ltd.

wilywit wrote:
> Hello,
>
> I'm working with a vendor who uses your DBISAM database. I'm connecting via your ODBC product through .net 2.x. The vendor tells me that inactivity
> will cause the database to timeout, so I can't leave me connection open for long periods. So, I tried to duplicate this so I can see what error message is
> thrown. However, I can't seem to make it error!
>
> I can open an ODBC connection, then go to Server Administrator and disconnect the session. Then, I let my app continue, and it somewhow seems to
> reconnect! I go back and look iin Server Administrator and the connection is back again.
>
> Does the ODBC driver take care of this somehow or am I not duplicating the test correctly?
>

<< I'm working with a vendor who uses your DBISAM database. I'm connecting
via your ODBC product through .net 2.x. The vendor tells me that inactivity
will cause the database to timeout, so I can't leave me connection open for
long periods. So, I tried to duplicate this so I can see what error message
is thrown. However, I can't seem to make it error!

I can open an ODBC connection, then go to Server Administrator and
disconnect the session. Then, I let my app continue, and it somewhow seems
to reconnect! I go back and look iin Server Administrator and the connection
is back again.

Does the ODBC driver take care of this somehow or am I not duplicating the
test correctly? >>

DBISAM automatically re-connects as necessary to the server, even if the
session has been disconnected.  The only way to cause a re-connection error
is to remove the session completely from the database server.

--
Tim Young
Elevate Software
www.elevatesoft.com