ODBC Provider Can't retrieve blob data >32Kb

[Brob]

I'm posting data into a blob field using TUniquery with ODBCUniProvider (ODBC Driver for Progress OpenEdge 11.1)
This works fine.

However, when trying to retrieve data from the blob field using a TUniQuery or TUniTable the blob field data not is returned when the data size is greater than 32Kb. It doesn't matter if it's an image or text. Anything below 32kb is OK!

I've tested the Progress OpenEdge ODBC driver using BDE/TQuery and all works perfectly.

Is this a UniDAC bug?

[AlexP]

Hello,

Thank you for the information. We have reproduced the problem and will fix it as soon as possible.

[Brob]

Thanks Alex

Is there any workaround I can use until the fix is released?

[Brob]

One more question please!

When will the next release be?

[AlexP]

Hello,

Please specify the database you work with

[Brob]

Progress OpenEdge 11.1

Customers existing system - definately not my choice.

[AlexP]

Hello,

To solve this problem, we need access to your server, if you can provide access to it, please send us the connection parameters at alexp*devart*com

[Brob]

Just carried out the same test using MySQL ODBC driver 5.1) and it seems to have the same problem.
Only difference is when using:-
Tblobfield( UniQuery1.FieldByName('REPORT_DATA')).BlobSize

MYSQL ODBC driver returns correct blob size
Progress OpenEdge ODBC driver returns 32768 if over 32Kb and correct size if less than 32Kb

[AlexP]

Hello,

Unfortunately, the DataDirect ODBC driver can work with commercial MySQL server versions only. If you can give us access to your server, we will check this problem once more on your MySQL server.

[Brob]

Hi Alex

I did the test using the MySQL ODBC driver from MySQL not the ODBC Driver from Datadirect.

[AlexP]

Hello,

We have reproduced the problem on the standard MySQL and PostgreSQL drivers and will try to fix it ASAP.

[AlexP]

Hello,

We have fixed the problem with BLOB in ODBC, however, we have checked this fix on PostgreSQL and MySQL only. Please send your license number, e-mail and the IDE version to alexp*devart*com, in order for me to send the fixed version for you to be able to check the fix directly on the server you are using.

[Brob]

Alex, Did you get my email and attachment?

[AlexP]

Hello,

I have received your project and built it on a fixed version. I sent you a letter with a zip-archive including the application.

[Brob]

Thank you very much for the test application.
Unfortunately the problem isn't fixed for me.

I have sent you an email.