Kbase P113796: Microsoft Error 0700 querying datetime field in SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/02/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.0x
SYMPTOM(s):
Error querying datetime field in SQL Server
07001:[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
The schema holder is created using Open Edge 10.0B SQL Server Wire Protocol Driver
The connection is made through Open Edge 10.0B SQL Server Wire Protocol Driver
The error is only seen when there is a datetime field in the table in SQL server
Using Open Edge 10.1A Wire Protocol Driver for SQL server produces the same error
CAUSE:
This is a known issue being investigated by development
FIX:
Use Microsoft SQL server driver in ODBC DSN.