MyDAC inside IntraWeb

ben · Post by **ben** » Fri 05 May 2006 12:28

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

Antaeus · Post by **Antaeus** » Sat 06 May 2006 09:21

Please check values of FetchAll and Pooling options in your application.

ben · Post by **ben** » Sat 06 May 2006 11:17

FetchAll + Pooling set to true.
what else?

Antaeus · Post by **Antaeus** » Sat 06 May 2006 15:16

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.