Hi James

Thanks. I will use this as last resort. I would like however to rather close it from the app since multiple apps are calling the ASA server

>Hi Willie,
>
>There is a setting on ASA to have the database drop a connection after x time of inactivity "-ti minutes". But the real problem is the CA not sharing the connection propertly. I have not used CAs before so I can't help you there but there should be a way.
>
>>Hi
>>
>>I am using a cursor adaptor to access data on an ASA backend. After a while my server slows down and I discovered that the sessions were not closed on the ASA side. Under the connected users there all connections still shows as live. Is this an ASA configuration or should I be doing something in the adaptor class.
>>
>>Thanks
>>Willie