By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,839 Members | 2,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,839 IT Pros & Developers. It's quick & easy.

Run time error 3231

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.