Solved

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

Posted on 2004-09-03
3
3,418 Views
Last Modified: 2010-04-26
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!
0
Comment
Question by:Haveland
3 Comments
 
LVL 1

Expert Comment

by:bobsterboy
ID: 11977527
Does the table in question have a memo field?  Those tend to blow up in Access using ODBC with DB2
0
 
LVL 12

Expert Comment

by:fulscher
ID: 11977560
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
0
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 500 total points
ID: 11977597
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question