Hi

I have a problem with a double login when running a Delphi 3 app on Win NT
connecting to Sybase System 11 using DB Library.  The same mechanism does
not give problems when connecting to MSSQL

The user inputs his username and password - get's logged in and reads a
another system login table.  A app login name and encrypted password is
picked up and then used to perform the actual login.  

We have a very strict requirement that users may not see any data when
connect with any application to the Server other than the Delphi App which
controls proper acess.

The problem is that when I close the Tdatabase it crashes with a C00008
error.  As I mentioned under MSSQL this does not happen

Any ideas would appreciated

Fred Iworth
fiwo...@global.co.za

This a problem with the Sybase driver / Delphi debug mode, there is a
meant to be a patch / EBF for the sybase side.

We have a similar scheme but use two databases and one for the
permanent connection and another for the initial login to get the
second. Also use:

try
  LogiinDatabase.Connected := False;
except
  LogiinDatabase.Connected := False;
end;

The above works on our stuff but eventually we'll aply the patch.
There should a TI on the Borland site for this.

Cheers Darren.

Fred <fiwo...@global.co.za> wrote in article
<01bd509b$3eecc820$99ae21c4@fredi>...