Kbase P98556: An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/08/2005 |
|
Status: Unverified
SYMPTOM(s):
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: [OpenLink][ODBC][Progress Server]** Incompatible data types in expression or assignment (223)].
Query statement:
select count(*) from tablename where iFieldName = 1 and dFieldName > 11/16/04;
CAUSE:
The date value needs to be enclosed in single quotes.
FIX:
Enclose the data value in the query with single quotes:
select count(*) from tablename where iFieldName = 1 and dFieldName > '11/16/04';