Re: ADO dates and '0001-01-01'

cwahlmeier_at_data-tronics.com
Date: 03/24/05 

Date: 24 Mar 2005 15:48:36 -0800

Stu,

Date, Time and Timestamps are the such a pain in ADO. I would suggest
using a command object, but you say you cannot use one.
Next I would suggest that you select the date using a CHAR(anyDate). I
see your comment about fooling the recordset but failing the update...
Thus I wonder if the CHAR will meet the same demise.

Also, what is in your DB2CLI.INI file? There are several settings that
affect the interpretation of the date datatype. Many of them are
dependant on the version of your DB2 Client.

Another question, why doesn't the ADODB.Command object work for you?

Regards,

Craig Wahlmeier

Relevant Pages

  • Re: ADO Properties
    ... ADO.NET has same objects like Connection, Command object as ADO does. ... there is Dataset in place of Recordset. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: adVarWChar slower than adVarChar
    ... And the Command object persists between each call does it? ... Let ADO setup the parameters ... Many VB programmers should be shot through the head because they allow the ... And does the SP have "SET NOCOUNT ON" at the top on entry? ...
    (microsoft.public.data.ado)
  • Re: Handle double quote in VB for MS Access
    ... Build a Command object with parameters and let ADO figure out the framing ... > If I use the following query in VB, on execution of ...
    (microsoft.public.data.ado)
  • Re: Exec SP with Cursors using ADO
    ... > I am trying to execute an SP which contains cursors etc....but when I ... > the RS using ADO, I seem to get an error? ... gaining ANYTHING using the Command object as you are. ...
    (microsoft.public.vb.com)
  • Re: Inserting Records Into Access Table via DAO
    ... > I'm used to using the command object in ADO to insert records into an SQL ... Another way is to use the RunSQL command object. ... Dim iIntVal as integer ... The downside is that the query will not be optimized. ...
    (microsoft.public.access.modulesdaovba)