Kbase P31225: ODBC error when querying tables with Date fields with a COMM
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/5/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3E
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Crystal Reports 9
FACT(s) (Environment):
MERANT 3.70 32-BIT Progress SQL-89
FACT(s) (Environment):
MERANT 4.0 32-BIT Progress SQL-89
SYMPTOM(s):
ODBC error when querying tables with Date fields with a COMMAND in Crystal Reports 9
Query Engine Error: '22008[MERANT][ODBC PROGRESS Driver] Datetime field overflow. Error in column <column number>.
Query Engine Error: '22018[MERANT][ODBC Progress Driver]Invalid character value. Error in column <column number>.
Using SQL-89 ODBC driver to make the connection
Querying tables without Date fields via a COMMAND succeeds, i.e. "SELECT * FROM customer"
Querying tables with Date fields via a COMMAND fails, i.e. "SELECT * FROM order"
Specifying non-date fields in a query against a table with Date fields via a COMMAND succeeds, i.e. "SELECT ordernum, custnum FROM order"
CAUSE:
The Default Date Format of the SQL-89 ODBC driver is not the same as the date format of the Progress database.
FIX:
Ensure that the Default Date Format of the SQL-89 ODBC driver is the same as that of the database.
- Connect to database via Data Administation
- Select Utilities from the menu and choose Information
- Check the '-d dmy date setting' in Environment/Startup Parameters
- Start ODBC Data Source Administrator
- Select the relevant DSN and choose Configure
- Select the Advanced tab
- Check the Default Date Format is the same as that of the Database