I am upgrading code, having shifted from a PFC200 750-8217 (32 bit) to the PFC300 750-8302 (64 bit). For the PFC200 we are using Firmware 04.07.03(29), CODESYS V3.5 SP21 Patch 1, and version 1.6.2.6 of the WagoAppSQL_MySQL library. This combination generally works well. On the PFC300, we are using Firmware version 04.09.01(31), CODESYS V3.5 SP21 Patch 5 and version 1.7.1.1 of the WagoAppSQL_MySQL library - version 1.7.1.1 seems to be needed to resolve variable errors on the PFC300 as reported (here). In version 1.7.1.1 of the WagoAppSQL_MySQL library, FbMySql_Login seems to work fine, and reports xConnected = TRUE after initialisation. Unfortunately, whe I then move on to submit database requests via either FbMySql_Execute or FbvMySql_Query, the system reports the error: “MYSQL-ERROR: Not connected with database, LOGIN before use”.
There is a minor change to the arguments of FbMySql_Login, which now includes the input refTLSContext. I have added this input, but the errors following database requests have not been resolved. Would be very grateful for any advice you could offer to help resolve this issue.