Help with odbc an Ms Access

D

DSHLP

New Member
Hello, i am working with Progress 9.1 E and Ms Access as frontend for report generation. I can see and update almost all tables, but with some ones in some especific fields i got the next error message: "Column XXX in table YYYY" has exceeding its max length or precision", i have full administrative rights and full access to the database, can any one help me to solve this issue?
 
I am having the same problem with SQL Server 2005, I am using SSIS to copy data from Progress to a SQL Server table. I have found that the field in question is set to 80 chars and there are entries in this field 182 chars long. I tried setting the size to 200 in SSIS and I get the same error.

This is a Progress error not a SQL Server error so that is why I am sure it does not matter that I set the size to 200. Is there any way around this on the Progress side.
 
Use dbtool on your database:

Code: 
dbtool path/to/database/databasename

option 2.

Casper.
 
You must log in or register to reply here.
Back
Top