[QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid

[AkrooS]

Hi guys, first thank you for support me in this error, after this I want to say that I'm desperate about this error, for more than 6 days working hard trying to fix, but I'm now the fail face guy :(

Well,
I have a MuEMU S4 F-TEAM copy, and everything is running good except for this error in my ODBC system. My error occurs in DATASERVER, and after some testes I could see that happens after 72h online randomly, or when some character get PK stage 2 status.
In cases listed above, DATASERVER just crush showing a several "[QueryManager] State (24000), Diagnostic: [Microsoft][ODBC SQL Server Driver]Invalid".
I already troubleshoot it, but this error message don't give me a clear way about how to be fixed.

Guys my configs is:
MuEmu S4 F-Team.
Windows Server 2012 R2.
SQL 2012 Enterprise x64 (Already tried in SQL 2014 EXPRESS and 2008 EXPRESS).

Troubleshoot:
- Change dataserver to another one, without success.
- Reinstall Windows server and SQL, without success.
- Install ODBC drivers including manually, nothing.
- Allow connections ports.

Please, check image from error:


PLEASE GUYS, give me some tips, I'll be really grateful!!!!!!!!!!!!!

[MentaL]

[SmileYzn]

DataServer is simple did not connected with SQL server.

[AkrooS]

DataServer is simple did not connected with SQL server.

Thanks for your reply!
Well this error just occurs after some minutes, I can log in my server, another players too, but this error occurs randomly, and I tested ODBC connection with SQL Server and at first time connects.
I'm suspecting that are losing connection with SQL, could you please help me to really confirm it? ;(

My Website is online, all ranking and databases are working there ;x

[SmileYzn]

No it really do not connect, since this emulator do not throw any erron if connection fails.
It just still working but disconnected

[AkrooS]

Nice, got the point!
Well, My OS is x64, and when I connect ODBC 64-bits I get "Could not connect" error message in Dataserver, and when I configure a 32-bits ODBC it connects but now that you tell me this, I'm confused.
For example, somethings like earned XP, or items gets normally saved on SQL, but when SQL need to perform a consult, this problem occurs, this is it?

I'm confused about how it can works ;(
Could you help me to fix it please?

[AkrooS]

Hi guys!
After 8 days, I didn't have any answer from this error, and even a little tip if is completly ODBC/Connection error, or corrupted compiled source code. Another thing rings a bell, multi-boxing, maybe is the case?
Please someone could help me out? ;x

[lacovic]

are u using the Ferrarezi website?

[AkrooS]

are u using the Ferrarezi website?

Yes, ferrarezi Web! There is something linked in that thing?

[lacovic]

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[Z_PK_HERO] ON [dbo].[Character]

AFTER UPDATE

AS



SET NOCOUNT ON

SET XACT_ABORT ON



DECLARE @rank int

DECLARE @valor int

DECLARE @char varchar(10)



SELECT @valor = PkCount FROM DELETED

SELECT @rank = PkCount, @char = Name FROM INSERTED



IF (@rank > 0) and (@rank > @valor)

UPDATE [dbo].[Character]

SET Z_RankPK = Z_RankPK + (@rank-@valor)

WHERE Name = @char

ELSE

IF (@rank < 0) and (@rank < @valor)

UPDATE [dbo].[Character]

SET Z_RankHR = Z_RankHR + (@valor-@rank)

WHERE Name = @char



SET NOCOUNT OFF

SET XACT_ABORT OFF

Roda essa Query, e veja se resolve! :)

Run this Query, and see if resolve this problem

[AkrooS]

Roda essa Query, e veja se resolve! :)

Run this Query, and see if resolve this problem

Vou testar hoje essa query, na parte da tarde eu te respondo! Eu tinha suspeitas que poderia ser uma store procedure, vou testar e te aviso, obrigado!!!!

I'll gonna try it today and i'll give a feedback! Thanks for your reply. I'm already had suspects in a stored procedure causing that.

[AkrooS]

DEU MUITO CERTO!
Você salvou a minha vida cara. Depois de 7 dias quebrando a cabeça, enfim está resolvido, não sei como te agradecer man!
Obrigado do fundo do coração kkk!
Espero que não tenha nenhuma outra Trigger com problema HAUHAUHA OBRIGADO!!

RUNS LIKE A CHARM!!!!!!!!!!!
You save my life man! After 7 hard days breaking my mind, it's well resolved, I don't know how to be grateful!
Thank you from deep of my heart!
I pay for god to don't have any more trigger to be changed like this URHRUHRUH THANK YOU!!!