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,375 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

Suggested Solutions

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now