Sergey explained how to do it. Thank you for your input.
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
