Kbase 15084: ODBC update failed when using VB 3.0 updates,creates,delete
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/07/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 7.3B
ODBC
Visual Basic 3.0
SYMPTOM(s):
ODBC updates fail.
** Table <name> does not exist or cannot be accessed. (962)
CAUSE:
You receive this error when updating creating or deleting records with zero length fields.
FIX:
The solution is:
-Make sure you have a unique index defined.
-Make sure you have nflag=1 set under the appropriate data source in the odbc.ini file.
-Also if using triggers make sure the -trig is used in the connection parameters.
-Also make sure they are on the latest Progress patch 7.3B07 or higher.