Re: ADO DB2 Exception Error

From: Bernhard Geyer (Bernhard.Geyer_at_gmx.de)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 21:28:48 +0200

Perhaps the ODBC-DB2-Driver is too old and doen't implements all
features correct as it is needed by OLE DB (ADO).

I you realy want to use ADO, you should donwload and install a ADO/OLE
DB-Driver from IBM.

Perhaps it would be better to use some native components (like
SQLDirect (http://www.sqldirect-soft.com/)) that supports the native
DB-Interface instead of using some common interfaces like ADO/OLE DB and
Access.

You get less problem with a native connection like

Your App -> SQLDirect -> DB2-Native Interface -> DB2-Database

than

Your App -> ADOExpress -> ADO -> ADO-Driver for ODBC -> DB2-ODBC-Driver
-> DB2-Native Interface -> DB2-Database.

Nigel Huband wrote:
> 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.NET Not Returning Error
    ... > a catch (Exception e) so the error should be captured if there is one. ... > but I get nothing back from ADO for this statement. ... > queries and when a user types in a query of this format, ...
    (microsoft.public.dotnet.framework.adonet)
  • D7 & ADO with ASA9: EOLEException & Multiple-step error
    ... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
    (borland.public.delphi.database.ado)
  • Re: Problems using ADO with multi threading
    ... ListIndexOutOfBounds is VCL (not MS ADO) exception, ... create new data module instance for every thread. ...
    (borland.public.delphi.database.ado)
  • Re: ADO.NET Not Returning Error
    ... > a catch (Exception e) so the error should be captured if there is one. ... > also get other info messages, ... > but I get nothing back from ADO for this statement. ... > queries and when a user types in a query of this format, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET Not Returning Error
    ... a catch (Exception e) so the error should be captured if there is one. ... also get other info messages, ... but I get nothing back from ADO for this statement. ... queries and when a user types in a query of this format, ...
    (microsoft.public.dotnet.framework.adonet)