converting entire input string"- "Error detected by database DLL"
All my reports who select by date/time field give this respond. I locked at the SQL query and found this(lock at the date):
SELECT
CC_CLIENTS."NAME",
CC_CALLS."TIME", CC_CALLS."CALL_TYPE", CC_CALLS."CONNECTED"
FROM
"CC_REPORTS"."CC_CLIENTS" CC_CLIENTS,
"CC_REPORTS"."CC_CALLS" CC_CALLS
WHERE
CC_CLIENTS."ID" = CC_CALLS."CLIENT_ID" AND
CC_CLIENTS."NAME" = 'Ellos' AND
CC_CALLS."TIME" >= {ts '2001-10-12 00:00:00.00'} AND
CC_CALLS."TIME" < {ts '2001-10-19 00:00:00.00'}
This happened after installing CR 8.5 on Win 2000. I can't find anything wrong in "regional options" ore "options" in CR. I have reinstalled the ODBC driver. I'm gone reinstall CR now, if that doesn’t help I hope I can find some help her in this forum.
Rune Flaathen
SNT-Norway
All my reports who select by date/time field give this respond. I locked at the SQL query and found this(lock at the date):
SELECT
CC_CLIENTS."NAME",
CC_CALLS."TIME", CC_CALLS."CALL_TYPE", CC_CALLS."CONNECTED"
FROM
"CC_REPORTS"."CC_CLIENTS" CC_CLIENTS,
"CC_REPORTS"."CC_CALLS" CC_CALLS
WHERE
CC_CLIENTS."ID" = CC_CALLS."CLIENT_ID" AND
CC_CLIENTS."NAME" = 'Ellos' AND
CC_CALLS."TIME" >= {ts '2001-10-12 00:00:00.00'} AND
CC_CALLS."TIME" < {ts '2001-10-19 00:00:00.00'}
This happened after installing CR 8.5 on Win 2000. I can't find anything wrong in "regional options" ore "options" in CR. I have reinstalled the ODBC driver. I'm gone reinstall CR now, if that doesn’t help I hope I can find some help her in this forum.
Rune Flaathen
SNT-Norway