Problem with AccountEdge ODBC driver and UniConnection

[bogdan]

Hello,
My situation is like this:
1. My setup is Delphi XE7, UniDAC 6.1.6, driver MYOCA1503 (comes as an add-on with AccountEdge CA 2015)
2. I have a database with a functional DSN named "accountedgeCa1"
3. I start my uniConnection and activate a TUniTable in this configuration:
Provider Name=ODBC;Login Prompt=False;Server=accountedgeCa1,
Options.DSNType=ntAuto
everything works ok yet my table shows only one record, instead of 4 (in the database).
4. I tried connecting with a TADOConnection and a TADOTable, all the records are showing. The ConnectionString I used is:
Provider=MSDASQL.1;Persist Security Info=False;Data Source=accountedgeCa1;
5. If I link the table in Microsoft Access all the records are also visible.

What am I doing wrong?
Thank you,
Bogdan

[bogdan]

I have found a similar case here: http://forums.devart.com/viewtopic.php? ... dbc#p99450.
The workaround works also in my case.
Yet, setting FetchRows:=1 it's quite confusing.
Is there any chance to get a fix for this situation in one of the future releases?
Thank you,
Bogdan

[AlexP]

Hello,

To solve the problem, set the ColumnWiseBinding SpecificOptions to True.

[bogdan]

Hello,
Unfortunately, the ColumnWiseBinding trick doesn't seem to work.
Up to this moment the only thing that works is setting FetchRows to 1.
Bogdan

[AlexP]

We have reproduced the described problem and will investigate the reason for such behavior.