Improve company productivity with a Business Account.Sign Up

x
?
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
Medium Priority
?
3,646 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 2000 total points
ID: 11977597
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

584 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