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,425 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

762 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