Hi Christian

Thanks for the reply. The CA opens the table all fine. I update and do changes - No problem. When I exit the connection is still active and it stays active. I see James says that I can set a timeout on the ASA server but I would rather want to close the connection though my code.

I have added no code to disconnect the connection since I have added no code to open the connection except for specifying the connection to be used.



>Hello,
>
>i know nothing about this ASA DB but the CursorAdapter itself (without additional code by you) will not make connections by itself .. you'll have to explicitly set CursorAdapter.DataSource to either a valid connection handle returned from SQLCONNECT/SQLSTRINGCONNECT or with a ADODB.Connection object
>
>i would check your CA class code, and if it calls SQL(STRING)CONNECT or instantiates ADO Connection objects, verify if a corresponding SQLDISCONNECT() is called or that the ADO Connection object is explicitly destroyed
>
>
>
>Regards
>Christian