SQL Error: request synchronization error

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
amonteiro
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: 20.07.2022, 15:11

SQL Error: request synchronization error

Post 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?
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1918
Joined: 17.01.2011, 14:17

Re: SQL Error: request synchronization error

Post 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
Post Reply