Kbase P28998: How to manually modify the Default Date Format in an SQL-89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/07/2003 |
|
Status: Unverified
GOAL:
How to manually modify the Default Date Format in an SQL-89 ODBC FILE DSN
FIX:
1) You will need to create a File DSN (instead of a System DSN or
User DSN) through the ODBC Data Source Administrator.
2) Once you have created it and tested the connection, modify the
file just created (by default this file is kept in the directory:
C:\Program Files\Common Files\ODBC\Data Sources). Using a text
editor (such as, Notepad), add (or modify) the following lines:
DDF=<date-format>
NOTE: Once you have done this, you cannot modify or save the File
DSN through the ODBC Data Source Administrator because it will
overwrite the file that you modified and you will need to add the
two lines again.