Kbase P159939: Getting Microsoft error 37000 when inserting in two tables in MS SQL server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/04/2011 |
|
Status: Unverified
SYMPTOM(s):
Getting Microsoft error 37000 when inserting in two tables in MS SQL server
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '@P34i'.
Same query executes correctly in previous versions of Progress / OpenEdge
FACT(s) (Environment):
OpenEdge 10.1x
Windows NT 32 Intel/Windows 2000
CAUSE:
Bug# OE00165068
CAUSE:
A specific part of the code had been changed in 10.1B to deal with variable length dbkey sizes. This code is to get the fixed size of the dbkey, so the product itself can compare with dbkeys passed by caller side.
Two issues were found. First one is about the way that tables communicate each other using internal calls once databases have different rules for a fixed dbkey.
FIX:
Regenerate or update the schema holder via Data Dictionary