Broken packet, data length ... exceeds field length

[alemio]

Hi, I'm using Builder c++ 6 and UniDAC to connect to SQL Server.
To workaround the error reported in my previous post (SQL server and datetime2) I'm using now Provider=prDirect.

If I have many data in a TUniQuery (i.e. 1300 rows) I have this error

"Broken packet, data length 65280 exceeds field length 256"

If I use Provider = prNativeClient I don't have this error.

What should I do? Should I create a new connection (I wouldn't do that)?

Regards
Alessandro

[azyk]

Unfortunately, we couldn't reproduce the problem. Please provide the script for creating the table structure, on which the problem is reproduced.

[alemio]

Hi, I'm trying to understand the error.
I can reproduce the error also with 1 record.
The problem occurs if in the database I have a nvarchar (max) field and this filed is filled by an empty string '' (with NULL it works and also with space ' ')

Regards
Alessandro

[azyk]

We have fixed this problem. Download and install the latest UniDAC version from http://www.devart.com/unidac/download.html

[gerham]

With ASE ODBC v1.1.3 I also get

('HY000', '[HY000] [Devart][ODBC][Adaptive Server Enterprise]Broken packet, data length 6 exceeds field length -2 (0) (SQLFetch)')

Seems to be related to TEXT columns?

Is anybody else using the ASE ODBC drivers or am I alone here?

[azyk]

Please specify the driver version and the version of Python and PyODBC.