Page 1 of 1

IBDAC Version 7.3.2 - Incorrect values within SQLDA structure

Posted: Wed 09 Dec 2020 09:59
by AsterixBT
Hello,

in IBDAC Version 7.3.2 with Delphi 10.4.1 Sydney is a new error: Incorrect values within SQLDA structure

In IBDAC Version 7.1.3 with Delphi 10.3.3 Rio it works fine.

In Unit IBCClasses.pas the result of variable RES = 0 in Version 7.1.3
and
in the new IBDAC-Version 7.3.2 the result of RES = 335544569

To reproduce the error:
Take a TIBCStoredProc
Take on Database Procedure with a Inputparameter of TYPE INTEGER
Example:
CREATE PROCEDURE MYPROCEDURE(
MYID INTEGER)
AS
DECLARE S1 VARCHAR(10);
BEGIN
S1 = 'Say Hello';
END

IB_StoredProc1.StoredProcName := 'MYPROCEDURE';
IB_StoredProc1.prepare;
IB_StoredProc1.ParamByName('MYID').AsString := '2';
IB_StoredProc1.Execute;

I hope, the error will be find fast, because we Update Delphi, Komponents an our custom projects and now our customer are waiting.

Thanks for a quick help
Gerd (from Germany)

Re: IBDAC Version 7.3.2 - Incorrect values within SQLDA structure

Posted: Thu 10 Dec 2020 11:45
by oleg0k
Hello,
Thank you for the information. We've reproduced the issue and are currently working to resolve it. We'll keep you updated on the progress.

wbr, Oleg
Devart Team

Re: IBDAC Version 7.3.2 - Incorrect values within SQLDA structure

Posted: Sat 17 Apr 2021 19:44
by oleg0k
Hello,
We've fixed the issue. The change will be included in the next release. If you urgently need the fix, we can send you the nightly build. If so, please send us your IBDAC license number, using the form: https://devart.com/company/contactform.html

wbr, Oleg
Devart Team

Re: IBDAC Version 7.3.2 - Incorrect values within SQLDA structure

Posted: Tue 20 Apr 2021 11:26
by AsterixBT
Hello,

Thank you for the good news.
When will the new version of IBDAC and UniDAC be released, since I have both licensed packages installed and there are version conflicts when I update only IBDAC?
If it is still this week, then I can wait.

Best regards from Germany

Re: IBDAC Version 7.3.2 - Incorrect values within SQLDA structure

Posted: Wed 21 Apr 2021 15:27
by ViktorV
Hi Gerd,

Sorry for the confusion in previous post reply.
Please note that the fix was already included into last build IBDAC 7.4.3 available for download from April 6th 2021.
All of the DAC products are based on the same core codebase, therefore, compatible versions of data access components should be installed in the same IDE, as indicated on the Compatibility pages, e.g. (https://www.devart.com/mydac/compatibility.html).
As a result, we advise you while updating one of DAC products you need to update all other DAC products used for this IDE.

Kind regards,
Viktor

Re: IBDAC Version 7.3.2 - Incorrect values within SQLDA structure

Posted: Thu 22 Apr 2021 05:27
by AsterixBT
Hello,

unfortunately the bug persists in IBDAC version 7.4.3 dated 6 April 2021.

My last answers already referred to this version 7.4.3.
Now I just checked it again.
The transaction error is still present with my example sent to them.
I need a solution here urgently.
Thank you very much.

Best regards from Germany

Re: IBDAC Version 7.3.2 - Incorrect values within SQLDA structure

Posted: Thu 22 Apr 2021 16:03
by ViktorV
Kindly note that our reply on forum was related to "Incorrect values within SQLDA structure".
Please be informed that the issue related to “invalid transaction handling” is currently being at work by our team. Once we have the resolution, we will immediately let you know.

Best regards,
Viktor