469,343 Members | 5,380 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,343 developers. It's quick & easy.

Run time error 3231

Moved a working MS Access application from Win2000 (version 5.0 SP 3)
OS with MS Access 2000 and DB2 Run-time client v7.1 FP 4 to XP (version
5.1, SP 2) OS with MS Access 2003 and DB2 Run-time client v8.1 FP 5.
This application has linked in objects some of which are Access tables
and others are Db2 tables and views. ODBC is used for connectivity.
When I run the mdb from the XP-Access2003-Db2v8 machine (also from
Win2000 (version 5.0 SP 3) OS with MS Access 2000 and DB2 Workgroup
Server Edition v8.1 FP 5) I get the following error "Run-time error
3231; ODBC--Field would be too long; data truncated.". But, when I run
the SAME mdb from a machine with Win2000-Access2000-DB2v7, no error
displays and the application runs flawlessly. I have looked at the
references in Access and made all the selections possible only to get
the same error. The query that populates the form runs fine when I
execute it by itself from the query tab in Access. On both machines
the Access ODBC driver is version 2.50 and regedit showed an entry for
the IBM DB2 ODBC driver but no version. At this point I am of the
opinion that the problem is between DB2 v8 and Access. Is there an
ODBC setting in patch1 or patch2 that I could set or make some entry in
the ini file that will relieve this run-time error? Or another
suggestion?!! I have exhausted all my ideas--please help. Thank you.

Feb 3 '06 #1
1 1861
rc******@idfpr.com wrote:
Moved a working MS Access application from Win2000 (version 5.0 SP 3)
OS with MS Access 2000 and DB2 Run-time client v7.1 FP 4 to XP (version
5.1, SP 2) OS with MS Access 2003 and DB2 Run-time client v8.1 FP 5.
This application has linked in objects some of which are Access tables
and others are Db2 tables and views. ODBC is used for connectivity.
When I run the mdb from the XP-Access2003-Db2v8 machine (also from
Win2000 (version 5.0 SP 3) OS with MS Access 2000 and DB2 Workgroup
Server Edition v8.1 FP 5) I get the following error "Run-time error
3231; ODBC--Field would be too long; data truncated.". But, when I run
the SAME mdb from a machine with Win2000-Access2000-DB2v7, no error
displays and the application runs flawlessly. I have looked at the
references in Access and made all the selections possible only to get
the same error. The query that populates the form runs fine when I
execute it by itself from the query tab in Access. On both machines
the Access ODBC driver is version 2.50 and regedit showed an entry for
the IBM DB2 ODBC driver but no version. At this point I am of the
opinion that the problem is between DB2 v8 and Access. Is there an
ODBC setting in patch1 or patch2 that I could set or make some entry in
the ini file that will relieve this run-time error? Or another
suggestion?!! I have exhausted all my ideas--please help. Thank you.


3231 is not a DB2 error message, so it has to originate from somewhere else.

Are you sure that you are using the DB2 CLI (ODCB) driver? The MS stuff
doesn't work reliably as far as I have heard.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Feb 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Carmine Cairo | last post: by
reply views Thread by rc | last post: by
1 post views Thread by rc | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.