In cursor adapter builder Tab 'properties' check use existing connection handle and write variable in who is sql handler

>Hello,
>
>I am using several cursor adaptors to access data from a external foxpro database. When I create the cursor adapter with a cursor adaptor builder , builder creates the init code of the cursor adaptor automatically. When I look to this init code, I see that Cursor adaptor creates a new ADODB connection object. This means everytime I create a cursor adaptor object , I open a new connection. So I create a new connection for all of my cursor adaptors because I have more than one cursor adaptor object in my application. In my opinion, this is unnecessary. Is there any way to make these cursor adaptor to share same connection object without creating new one?
>
>Thanks..