Not Enough Timers available when instantiating a TMyQuer

AndyB · Post by **AndyB** » Tue 14 Oct 2008 19:58

When the following steps are executed, (in the current server environment), instantiating the main form produces a 'Not enough Timers available' exception after about 10 seconds of doing something. Note this is without even assigning a connection to the query or even assigning a MySQL server to the connection. It is purely an object instantiation issue, not a connection issue. This occurs every time without fail.

Using MyDAC 5.50.0.36 compiled with Borland Delphi 2005 Professional and AtoZed Intraweb v7.2.36...

1) Create a new ISAPI extension application and elect not to Pool Data Connections.
2) Drop a TMyCOnnection and a TMyQuery on the main form, both with all parameters left as default.
3) Compile as an ISAPI DLL and deploy

A production application with the same components (and now with the same repeatable error) was working fine for 6 months until today and no changes had been made to the application at that time.

Another ISAPI application in the same environment compiled with an earlier version of MyDAC is still working.

The above 2 points would indicate that a server O.S / IIS configuration change or upgrade is now incompatible with this version of MyDAC. I am awaiting confirmation of configuration and O.S changes that may have taken place on the server but wanted to post asap to see if there was a known issue/fix. I have checked the release notes http://www.devart.com/mydac/History.html for later versions but this issue is not discussed.

Challenger · Post by **Challenger** » Thu 16 Oct 2008 07:31

TMyQuery uses TTimer for autorefresh operation. Can you specify the version of MyDAC that works well in your application?

AndyB · Post by **AndyB** » Thu 16 Oct 2008 12:00

Sure, v3.50.0.16 was working fine.

Thanks for the response.

Challenger · Post by **Challenger** » Fri 17 Oct 2008 10:34

We will fix this problem in the next build of MyDAC.

AndyB · Post by **AndyB** » Fri 17 Oct 2008 11:56

In the mean time, can you expand on what event may have triggered the bug on the server as it only started to fail recently without changes to the application.?

Also, is there any options I can set/unset on the Query object that will avoid the error for now?

Finally, how can I find out when the patch has been released. Will I be contacted?

Many thanks.

AndyB · Post by **AndyB** » Thu 23 Oct 2008 14:46

Could someone from the Devart team comment re my last post?
Many Thanks.

Challenger · Post by **Challenger** » Thu 23 Oct 2008 15:33

The next build will be available in two or three weeks. If this does not suit you please contact us by mail.

AndyB · Post by **AndyB** » Thu 23 Oct 2008 15:43

That's fine thanks.

Devart Forums

Not Enough Timers available when instantiating a TMyQuer

Not Enough Timers available when instantiating a TMyQuer

Any comment?