How to use connection pool

Hans · Post by **Hans** » Mon 09 Jan 2006 16:30

Hi,
I use the latest version of MyDac. I wonder if someone can tell me how to use connection pooling. I see that you can configure TMyConnection for pooling an specify the maximum of connections, but how do i get a connection for a TMyTable or TMyQuery. Can i get multiple connections from one TMyConnection or do i have to make multiple instances of TMyConnetion.

Please advise, since in the Help i donot find much information.

best regards,
Hans

Ikar · Post by **Ikar** » Tue 10 Jan 2006 10:55

You should make multiple instances of TMyConnection.

Hans · Post by **Hans** » Tue 10 Jan 2006 11:25

Thanks, i already tried and it works fine.

But: I think i found a bug in TMyConnection. This object has a proprty 'DataSetCount'. I use this together with the DataSets[] array to enumerate thru all connected datasets and refresh them.

It seems that DataSetCount is always 1 to much. e.g. when 2 datasets are connected DataSetCount = 3

Is it possible that this bug will be fixed?

best regards,
Hans

Ikar · Post by **Ikar** » Tue 10 Jan 2006 13:13

One connected dataset is a special dataset for secondary needs. It is used
for executing UPDATE etc satements.