Kbase P126977: Error 37000 when running a joint query containing a 'matches' or 'begin' condition against MS SQL Se
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/11/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1x
MS SQL DataServer
SYMPTOM(s):
Error 37000 when running an joint query
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'ORDER'.
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
The query contains a 'matches' condition.
The error also occurs when the query contains a 'begin' condition.
CAUSE:
Bug# OE00159429
CAUSE:
The SQL query sent to the MS SQL Server database is missing right bracket.
FIX:
Upgrade to OpenEdge 10.1B03