Link to home
Start Free TrialLog in
Avatar of Haveland
Haveland

asked on

db2 odbc link in Access returns "A buffer passed to a system call is too small to hold return data"

I try to link some tables from db2 database in access, using odbc. Most tables work just fine but the most important one gives me an error when I open it for viewing. It says:

 "[IBM][iseries Access ODBC driver]Column2:CWB0111-A buffer passed to a system call is too small to hold return data (#30200)[IBM][iseries Access ODBC driver]Character data right truncation (#30125)"

All the field in the tables shows #error

Help!
Avatar of bobsterboy
bobsterboy

Does the table in question have a memo field?  Those tend to blow up in Access using ODBC with DB2
Haveland,

I found a few references on the Web indicating that CWB0111 is an error in the ODBC driver of IBM. So, you should certainly report this to IBM or the Admin of the iSeries; there might be a fix available. If I understand the reports correctly, it appears that the problem has to do with wrong allocations of memory for strings (BYTE vs. UNICODE).

Anyway - Since most tables work fine, I would assume that it's only one, maybe two columns in the table which create a problem. I wonder whether you could create a query on the DB2 which contains only a subset of the fields and then link to this query - with some experimentation, you probably can find the culprit column(s). If you're lucky, you don't even need it / them.

Candidates:
- Strings
- Very long strings
- Memo or BLOB fields

Hope this helps you a bit...

Jan
ASKER CERTIFIED SOLUTION
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial