You can use the same ADO connection for all CAs.

>ADO
>
>>Which DataSourceType are you using in CA?
>>
>>>
>>>Does every CA object you create creates a connection to the SQL Server? And if so and your application may have several objects (forms) that have CA objects active, does it mean that such application uses several connections to the SQL Server at the same time? The reason I am asking is I thought that an application should use as few connections to the SQL server as possible. In fact when I am using the SPT approach the application is using just one connection established at the top of the application and this connection is used everywhere. How do you accomplish the same with CA?
>>>
>>>TIA.