Jerry,
if you have ONE connection to your BackEnd then, no matter how many CAs are opened you have ONE connection. Therefore you can't disconnect CA.

>yes, I use SQLDISCONNECT(0)
>
>the problem is when the client open multiple forms, one form close and all other forms are error.
>because it will close the connections not only itself, but for all the other forms as well.
>
>
>>I use a connection manager object that I built. That object is stored in my application object so I make the connection when I start my app an then I only use the one connection for the entire application. I have a SQLDISCONNECT(0) in the destroy of the connection object. All of your CAs can get the connection handle from the connection object when they are instantiated.
>>
>>>I use MySQL.
>>>close the form doesn't realease Cursor Adapter.
>>>so I will have the connections build up and reach the MySQL connection limit.
>>>
>>>
>>>
>>>
>>>>I have cursor adapter on Data Environment.
>>>>>how to release it?
>>>>>
>>>>>
>>>>>>>I'm using MySQL and Cursor Adaptor in Data Environment.
>>>>>>>how can I disconnect the CA connections when exit?
>>>>>>>if I use SQLDISCONNECT(0) it will disconnect everything, incl connections on other forms.
>>>>>>>
>>>>>>>thanks for the help
>>>>>>>
>>>>>>>regards,
>>>>>>>
>>>>>>>Jerry
>>>>>>
>>>>>>If you use ODBC connection and that connection is global for your application, there is no need to disconnect CA.
>>>>>>Just release it.
>>>>
>>>>Close the form.
>>>>Why should you release it?