Different behavior with 64bit Windows

[ralle1]

Hello,

I have got 2 windows systems with same Delphi and Devart Versions:
1) Win 7 prof SP1 32bit with Delphi 2007 and IBDAC 3.10.0.16
2) Win 7 prof SP1 64bit with Delphi 2007 and IBDAC 3.10.0.16

In both systems I start the same project with absolutely the same source code.
I build an executable of this project on both systems.

I use this executables on a third system. Both connect with the same database and the same SQL (Same folder, everything seems the same).

In the SQL there is no "order by" (I know this is wrong...).
Everything seems completely identical but the ordering is different.

What could be reasons for this differently behavior?
I really want to rule out that something is misconfigured. It’s a problem if the user will get different versions.

Thank you for help.

[AndreyZ]

Hello,

By default, IBDAC does not influence the ordering of data received from the server.
Please check the following:
- the IndexFieldNames property is blank. Otherwise, IBDAC performs local sorting.
- if you use the TClientDataSet and TDataSetProvider components, make sure the TDataSetProvider.Options.poRetainServerOrder option is set to True.
- make sure you are using the same IBDAC version on both Windows;
- make sure you are using the same Delphi 2007 version on both Windows;
- make sure you are using the same client library (gds32.dll or fbclient.dll) version on both Windows.
If it does not help, please try creating a small sample to demonstrate the problem and send it to andreyz*devart*com . Also please specify the following:
- the exact version of your Delphi 2007 (for example, 11.0.2902.10471 );
- the exact version of InterBase or Firebird server and client you are using. You can learn it from the Info sheet of TIBCConnection Editor.

[ralle1]

Hello,

Everything is exacly the same. The executables were tested on completely the same system. The only differences are:
- Compiling on 64bit Windows vs. 32bit Windows
- The compiling machines have local different firebird versions installed. So there are different client libraries. But on the destination machine it is for both executables identical.
- IndexFieldNames, TClientDataSet, TDataSetProvider are not used

[AndreyZ]

Please provide the sample and all the information I asked you in my previous post. Without this information I am not able to investigate this question.