Page 1 of 1

MyDAC inside IntraWeb

Posted: Fri 05 May 2006 12:28
by ben
Hello,

does anyone used MyDAC inside an IntraWeb application?
I have the following problem:

OnRender of IW App I have

DM.Connection.Connect

and on OnDestroy I have

DM.Connection.Disconnect


when I close the internet explorer window everything is fine but when I retype again the address on the bar http://127.0.0.1
it opens a new connection to the DB.

Im sure its not MyDAC problem, there is something Im doing wrong!

All your ideas are welcomed!

Thanks

Posted: Sat 06 May 2006 09:21
by Antaeus
Please check values of FetchAll and Pooling options in your application.

Posted: Sat 06 May 2006 11:17
by ben
FetchAll + Pooling set to true.
what else?

Posted: Sat 06 May 2006 15:16
by Antaeus
When Pooling option is set to True, after setting MyConnection.Connected to False, real connection to server stays established for some time to pick it up later and not to waste time on establishing new connection. This connection may not be picked up if parameters of new connection are different. For more information read MyDAC help.
As experiment try to set Pooling option to False and test your application once more.