Our VB 6 program access Oracle database using MS ODBC for Oracle. The
program is trying to run the following SQL stt:
select DATANOTES_NOTES from DATANOTES where EEI_KEY = 654 and DATANOTES_DATE
= TO_DATE('04/11/2002 11:10:45 AM','MM/DD/YYYY HH:MI:SS AM')
The Time Format and Date Format setting in Control Panel - Regional Setting
are the following:
Time Format: HH:mm:ss
Date Format: dd/MM/yyyy
For example: 11/04/2002 14:10:10 for April 11, 2002 2:10:10 PM
On a machine that uses MS Odbc for Oracle version 2.573.6019.00 I got an
[Microsoft][ODBC driver for Oracle][Oracle]ORA-01855: AM/A.M. or PM/P.M.
I do not get this error on a machine that uses MS Odbc for Oracle version
2.573.5303.00 or MS Odbc for Oracle version 2.573.7713.00.
Is this a problem with MS Odbc for Oracle version 2.573.6019.00?