Kbase P26675: Run-time error '3146' ODBC --call failed
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Windows
Progress 9.1D
SYMPTOM(s):
Microsoft Access Error Message: Runtime error -- 3146 odbc call failed.
SQL.LOG file includes the following diagnostic error line:
DIAG [S1000] [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Column vendor in table PUB.pur01 has value exceeding its max length or precision. (-210012)
Using MS Access 2002 program to read a progress table using an ODBC connection.
Program always errors on the same record and returns ODBC -- Call Failed - 3146.
SQL.LOG file reveals that the above diagnostic error is caused by the statement:
SELECT "vendor" ,"name" ,"add1" ,"add2" ,"add3" ,"city" ,"state" ,"country" ,"zip" ,"fob" ,"phone" ,"terms" ,"temp_perm" ,"ship_via" ,"plant" ,"vendor_status" FROM "PUB"."pur01"...
CAUSE:
The SQL-WIDTH of the field <vendor> is too small to accommodate its data.
FIX:
Use either 4GL or the data dictionary to adjust the SQL Width Property Setting of offending field(s)