ADO DB2 Exception Error

From: Nigel Huband (nhuband_at_nospam.hotmail.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 10:09:17 +1000

Hi, I'm maintaining some code that's throwing an exception on 'post' to a
DB2 (UDB) table.

It's using a Delphi TADOTable connecting through a TADOConnection object
using the DB2 v7.1 drivers through ODBC.

The strange thing is that it works on all other databases I've tried (SQL
Server, Access, etc).

It happens when the TADOTable has the 'append' method called, the data is
then populated then on the 'post' the exception occurs.

I think it might be related to a datetime variable being null as these
values were not set.

I don't suppose anybody else has had problems like this and might be able to
point me in the right direction?

Thanks in advance for all help.

Regards,
Nigel Huband.

Relevant Pages

  • Re: ADO DB2 Exception Error
    ... "Nigel Huband" wrote in message ... > then populated then on the 'post' the exception occurs. ... OLEDB provider still had bugs. ... we found DB2 to be more troublesome to get working ...
    (borland.public.delphi.database.ado)
  • CommandTimeout with DB2 not working
    ... I'm using ADO to connect to a DB2 v8.1.5 db running on Linux RH 3.0. ... The problem I'm seeing is no exception is thrown when the command ... I then expect to catch an exception if the command takes longer than ...
    (microsoft.public.data.ado)