Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Date update error - null to 11/30/1899 - Answer
Just in case anyone was interested -
Yes it was the 8.00.4 ODBC driver - once we went to one of the 8.00.5 drivers on the users machines the date error stopped.
Mike
Mikey <okana_at_email.msn.com> wrote in message
news:ugEPL8fq#GA.238_at_cpmsnbbsa05...
> Application developed in VB5
> Database connectivity using RDO/Oracle ODBC
> Server recently updated to 8.0.4 from 7.3
> Oracle Server is on NT4 SP4
> Client machines are Win95
>
> Two users machines whose ODBC have been updated to 8.0.4 are experiencing
an
> odd date error. When they update date fields in the application that are
> empty, the value that is saved to the database is 11/30/1899.
>
> The application sends a Null if there is no data in the field when an
update
> occurs. The Null value is being misinterpreted during the update.
>
> I found another date error issue that is similar for the 8.0.4 ODBC driver
> on technet.oracle.com but it is not this exactly.
> (ODBC:SQLBINDPARAMETER IGNORES SQL_NULL_DATA FLAG Report Number: 647207)
>
> Has anyone seen this or know about it or is it documented somewhere. My
> feeling is to update the ODBC drivers to at least the 8.0.4.3 drivers
> mentioned in the above article - will that fix it??
>
> Thanks in advance for any assistance I can receive -
>
>
> --
> Mike Milliron
> okana_at_msn.com
> mikem_at_msamail.com
>
>
Received on Tue Jun 01 1999 - 20:29:45 CDT