No. You should reuse the same connection as much as possible. Two reasons: 1) Connections take a long time to establish. If you keep opening/closing or simply opening a new one every time, your application will be slower. 2) SQL Server is often licensed on a per connection basis.
>Hi,
>
>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer