Kbase P122852: Error 37000 running query against SQL server database with Date field in query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/05/2008 |
|
Status: Verified
FACT(s) (Environment):
OpenEdge 10.1B
ODBC DataServer
Oracle DataServer
MS SQL DataServer
All Supported Operating Systems
SYMPTOM(s):
Error 37000 running query against SQL server database
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
Error occurs when date field is not at the end of the WHERE clause
Error occurs when there is equality in the query. If a range is used ( > or < ) then there is no error.
The query generated is not complete, see notes
CAUSE:
Bug# OE00147939
CAUSE:
Bug# OE00145625
FIX:
Upgrade to OpenEdge Service Pack OE10.1B01 or later.
If upgrade is not possible, use the following workarounds:
1. Reverse query string order, put date equality at the end instead of the beginning or in the middle
2. Use a range in query instead of equality