Kbase P7284: ODBC: wrong date time format using SQL-89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
MERANT 3.50 32-BIT Progress SQL-89
MERANT 3.60 32-BIT Progress SQL-89
MERANT 3.70 32-BIT Progress SQL-89
Progress 8.x
SYMPTOM(s):
Datetime field overflow
Error in column n
Querying a table containing a date data type field from MS Query
CAUSE:
MERANT (DataDirect) ODBC reads from the startup.pf on the server.
If you have specified this file the parameter -d dmy (European Date format).
The date retrieved by MS-Query will have the following format :
YYYY-DD-MM. This is an unknown format when reading from MS-Excel.
FIX:
1. Go thru ODBC Data Source Administrator, select the Data Source and
click on the Configure button, you will see the Advanced tab folder
Set the "Default Date Format" to DMY.
2. Start the OIB by specifying -d dmy as additional parameter.