0

I am using MyDac to connect MySQL and my Delphi Project, here is what is happening:

When I start the application, everything works fine but after some idle if I try to make a new search I get the error: 'Acess denied to user for routine myprocedure'

  • I'm using roles to control the permissions
  • I created a routine on mysql to run the select

After this, I need to restart the application

BDuarte
  • 129
  • 11
  • For FireDac you make sure any connection setup code is in `AfterConnect` so if the connection is lost and re-established it again gets setup the way you want. See if there is something similar for mydac. – Brian Sep 28 '20 at 19:59
  • This is probably a question to ask in DevArt forum or directly to DevArt tech support. See https://www.devart.com/mydac/ and click on "support" in the top menu. – fpiette Sep 29 '20 at 07:17
  • @Brian I have a query setting a role in AfterConnect – BDuarte Sep 29 '20 at 10:57
  • What kind of "idle" you mentioned before? Are you sure that your connection mechanic is correct for it? Could you give some detailed information? – Abdullah Ilgaz Nov 14 '20 at 07:03

0 Answers0