[dba-VB] Connection closed

John, this is just a wilda*s guess because I've seen this happen to me, but 
it may be the syntax you're using and you're just getting one of the less 
the helpful error messages.

The interesting word is "available" -- my guess is that one of your 
parameters isn't the right type of something obscure like that, but I really 
am only guessing.

Susan H.



> Any ideas out there? The ExecuteNonQuery complains that the connection is
> closed.  If I break at that point (the catch) and do a lcnn.open it says 
> the
> connection is open.  Further it tells me the name of the server, the table
> name etc.  Doesn't sound closed.