re-connect fails with "[DBNetlib][Connectionread (Recv()).] General network error. Check your network documentation ..."

My app allows the user to sign-in again with a different set of credentials
and settings. Something is not working right when I disconnect and
reconnect.

function mySessionSingleton.Connect:boolean;
begin
with fmyconnection do begin
if connected
then connected := false;

....
code to set connection string.
....
try
connected := true;
result := true;
except on e: exception do begin
result := false;
ShowMessage(e.Message);
end;
end;
end;

The function seems to work -- the connection is set to false, new string
built, connected:=true succeeds. The problem comes later when trying to run
a tadostored proc with the connection. The following error happens:

"[DBNetlib][Connectionread (Recv()).] General network error. Check your
network documentation ..."

What else besides "connected:=false;" should I be doing?

Jeremy



.

Relevant Pages