Page 1 of 1

SQL Error: request synchronization error

Posted: 25.03.2024, 15:00
by amonteiro
Hi,
I am trying to execute in a clientdataset the follow command text:

SELECT VENDABUSCADESC FROM GETPERMISSAO(27400001)

But i receive ths error:

Remote error: SQL Error: request synchronization error; GDS Code: 335544364; Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Code: -901 Message: isc_dsql_free_statement

I am using Firebird 2.5.9.27139. Is this some configuration in the datasetprovider?

Re: SQL Error: request synchronization error

Posted: 26.03.2024, 15:32
by marsupilami
Hello amonteiro,

I found a simi98lar problem (TClientDataset, Firebird, request synchronization error) in the german Delphi Praxis:
https://www.delphipraxis.net/177886-fir ... error.html

The solution there was to only call Open onm the client datasets but not on the datasets that were used for data retrival.

With best regards,

Jan