Progress SQL ODBC errors:
i) System.Data.Odbc.OdbcException: ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Invalid number string (7498)
SOLUTION: Lookup Type/Value Not Found - check values bound to lists/types
ii) [PROGRESS]Lock table is full. (7870)
sol: # Lock Table Entries is too small. Increase in ODBC connection properties.
iii) [System.Data.Odbc.OdbcException] = {"ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Character string is too long (8184)"}
SOLUTION: Text in a Formatted field (Date or Time or Currency...) contains invalid or extra characters (" ", leading space).
iv) [ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.
[OPENEDGE]Broker rejects connection
SOLUTION: PEO database is not setup for SQL (4GL only) OR Database needed a restart.
1 comment:
Thanks for the hints on what these OpenEdge errors mean. I wish one of these offered the key to fixing my immediate problem, but either way, I'll know a few things to look for when I have other problems.
Post a Comment