Nicole,
I just got mine to work today. My .fmt row specifies SQLCHAR, 25 wide,
""(no terminator-flat file), and the data in my file looks like "02/05/1999
" (without the quotes of course. Good luck!!
Tom
by Tom Breidal » Sun, 07 Feb 1999 04:00:00
I just got mine to work today. My .fmt row specifies SQLCHAR, 25 wide,
""(no terminator-flat file), and the data in my file looks like "02/05/1999
" (without the quotes of course. Good luck!!
Tom
1. error ORA-01855: AM/A.M. or PM/P.M. required
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
error
[Microsoft][ODBC driver for Oracle][Oracle]ORA-01855: AM/A.M. or PM/P.M.
required.
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?
Thank you.
3. Problems with bcp format file for Fixed Length file
5. BCP requires file to be local but...
6. How to refresh custom SQL code?
7. BCP requires file to be local to server.....
8. 1 * NOAzDlZIm-The horrors of SQLMail with POP3/SMTP
11. Format required for the Audit files created in 5.0 online
12. Using BCP Format File option