Hello

 I recently migrated to Mysql 8.0 (from 5.6) and I am having an issue with my reporting application, when accessing a report that calls a stored procedure, i am receiving this error:

I searched about it, and it seems that Mysql 8.0 does not have that table anymore that was needed before to access a stored procedure.

Investigating, looked into the MySQL driver installer /dll and is 8.0.18

But looks like the MySql.Data.dll drivers  that power server is using are not updated (I found two places C:\\inetpub\\wwwroot\appeon\AEM\bin

and

C:\\inetpub\\wwwroot\appeon\Toolkit\status monitor).

I tried to manually replace the old ones with the new one and resulted in a error, when running my web application (see error from my appeon logs), I had to put it back, it seems that in some harcoded place is looking for the Version=60308, but i couldnt find it .

Please I need some help with this issue, I'd appreciate if any other light can be shed on this.

"

2023-03-22 08:54:37.099 : [Application name=reports,conn cache=SQLCA]Could not load file or assembly 'MySql.Data, Version=6.3.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
   at Appeon.Server.Services.DataService.DataServiceFactory.CreateDBConnection(PBTransactionProperties pbTrans, String connCache, String ext)
   at Appeon.Server.Services.DataService.DataServiceFactory.CreateDBConnection(PBTransactionProperties pbTrans, String connCache)
   at Appeon.Server.Commands.ConnectDBCommand.AttempToConnectDatabase()
   at Appeon.Server.Commands.ConnectDBCommand.Execute()

"

Thank you in advance for your help.

Tatiana.