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?