Kbase P146485: SYSTEM ERROR 6175 and ODBC Error 22008 When Querying Specific Data Field in SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/2/2009 |
|
Status: Verified
SYMPTOM(s):
Error occurs when querying specific data field in MS SQL server
SYSTEM ERROR: Date/Time format error. (6175)
22008:[Microsoft] [ODBC SQL Server Driver] Invalid date format
SQL generated by data server turns equality date query into range match
FACT(s) (Environment):
Only errors out when querying specific date value, querying other date value works
The date field is at the end of the query string's where clause
Error did not occur in OE 10.0B
Occurs in 10.1C03 service pack
OpenEdge 10.1C03 Service Pack
Windows
OpenEdge 10.1C
CHANGE:
Upgraded to OE 10.1C
CAUSE:
Bug # OE00181560 / OE00184596
FIX:
Reorder the criteria in where clause, move the last date equality ahead so it is not at the end of query string
This workaround would not address the wrong SQL problem.
for example,
for each order where order_num ="10" and
order_date="02/20/2009"
is changed to
for each order where order_date="02/20/2009" and
order_num="10"