Kbase 17634: ODBC V3.01 or MERANT 3.50 Driver : Wrong Date time Format
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/6/1999 |
|
ODBC V3.01 or MERANT 3.50 Driver : Wrong Date time Format
ODBC V3.01 or MERANT 3.50 Driver : Wrong Date Time format
INTRODUCTION:
============
This knowledgebase explains how Intersolv ODBC 3.01 (32 bits) and
MERANT 3.50 32-BIT Driver works with the date formats.
WHY YOU NEED TO KNOW THIS:
=========================
You may hit the following error when importing data from Ms-Query
that has been retrieved through ODBC.
[INTERSOLV][ODBC PROGRESS Driver] Datetime field overflow. Error in
column n.
The data will not appear on the excel sheet.
It could also be that you don't get the error and the data that will
appear doesn't have the correct format. You may test this by changing
the column to date format.
PROCEDURAL APPROACH:
===================
Intersolv (MERANT) 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.
The way you solve this problem is depending of the ODBC Driver you are
using.
- If you are using Intersolv 3.10 ODBC Driver:
This problem is fixed in V3.10 by adding internal date format
support using a checkbox in the Advanced setup dialog. The checkbox
is called 'Use International Date Format'. Go thru ODBC Data Source
Administrator, select the Data Souce and click on the Configure button
and you will see the Advanced tab folder.
- If you are using Merant 3.50 32-BIT Progress ODBC Driver :
1. Go thru ODBC Data Source Administrator, select the Data Souce 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.
ON-LINE PROCEDURES OR UTILITIES:
===============================
You may erase the -d dmy from the startup.pf file but make sure
if your clients read from this file that they have set this parameter
set for them, otherwise they will see dates with the english date
format: MM/DD/YY instead of DD/MM/YY.
ebi
30/01/1998
mbc 30/07/98
jmr 06/09/99
Progress Software Technical Support Note # 17634