- The cause was not ODBC: the Ferrarezi website adds a trigger
Z_PK_HEROondbo.Characterthat fires whenPkCountchanges, and its old version broke the DataServer queries. - In SQL Server Management Studio run
ALTER TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character] AFTER UPDATEwithSET NOCOUNT ONandSET XACT_ABORT ONat the start andSET NOCOUNT OFF/SET XACT_ABORT OFFat the end, keeping its logic: readPkCountfrom DELETED and INSERTED, add the increase toZ_RankPK, or add the decrease toZ_RankHRfor heroes. - Restart DataServer and test by getting a character PK.
- Check any other website triggers on game tables the same way.
DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)
Autor tematu potwierdził, że to zadziałało.
Autor tematu, 2018-04-09 (oryginalne słowa)Oryginalne słowa (portugalski)
“DEU MUITO CERTO! Você salvou a minha vida cara.”