Re: Getting date/time fields from Oracle with ADO

From: Cesar Ronchese (ronchese_at_smlinfo.com.br)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 15:56:36 -0300

The Oracle Enterprise Manager is showing DATE, but ADO shows datatype 135
(TimeStamp).

"Douglas Marquardt" <no_spam@dummy.com> wrote in message
news:Oi8aNfgBEHA.2768@tk2msftngp13.phx.gbl...
Hi Cesar:

Can you verify that the field in Oracle was created using the
"DATE" datatype and not "TIMESTAMP"?

Doug.

"Cesar Ronchese" <ronchese@smlinfo.com.br> wrote in message
news:%23Qf2$ZgBEHA.1140@TK2MSFTNGP10.phx.gbl...
> Hello, guys!
>
> I'm migrating from SQLServer (7) to Oracle (9.i release 2), so my software
> can support multi-databases. In SQL Server, all works fine.
>
> However, testing my programs in Oracle, I got a problem with fiels in Date
> datatype, when that field use date/time togheter.
>
> See the following sample:
>
> Dim cnn As New Connection
> Dim rs As New Recordset
>
> 1 cnn.Open "Provider=MSDAORA.1;Password=PWD;User ID=USER;Data
> Source=NAME;Persist Security Info=True"
> 2 rs.Open "select doctype_insertdate from doctype", cnn
> 3 Debug.Print rs("doctype_insertdate").Value
>
>
>
> The error occurs when I try get the value in line 3, above. The message
is:
>
> Run-time error '-2147217887 (80040e21)':
> Mulitple-step OLE DB operation generated errors. Check each OLE DB status
> value, if available. No work was done.
>
>
> If I remove the time from field (directly in database), the code above
work.
> But, I need to get the date and time from that field.
>
> Anyone have a solution for this problem?
>
> Tks in advance!
>
> []'s
> Cesar
>
>
>
>
>

Relevant Pages

  • Re: Getting date/time fields from Oracle with ADO
    ... "DATE" datatype and not "TIMESTAMP"? ... > However, testing my programs in Oracle, I got a problem with fiels in Date ... > Dim cnn As New Connection ... > Mulitple-step OLE DB operation generated errors. ...
    (microsoft.public.vb.general.discussion)
  • Crystal Reports 9 and Oracle WITH LOCAL TIME ZONE supported?
    ... CR v9 erroneously creates the Oracle 'WITH LOCAL TIME ZONE' as stringdatatype instead of timestamp or date. ... Does anyone know if there is a workaround or a HotFix for this? ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: problems inserting a utf8 timestamp with DBD::Oracle
    ... Don't think so as I'm not using Oracle 9. ... Well I'm not saying it isn't a bug in Oracle but this one is a real problem I cannot easily workaround as really I need a timestamp and a date. ... Client is Oracle 10.2.0 XE ... If you then comment out the 2nd block of code and uncomment the 3rd block of code it works i.e it appears it does not like having a timestamp and a date in the same insert. ...
    (perl.dbi.users)
  • Re: question about substr
    ... Oracle then compares the values character by character up to the first ... CHAR, NCHAR, text literals, or values returned by the USER function. ... What is the datatype of substr? ...
    (comp.databases.oracle.server)
  • Re: suggestions sought on returning rows from oracle proc and deleting them in same proc
    ... this is not Perl stuff but Oracle PL/SQL. ... deleting them in same proc ... create mytable (id int, created timestamp); ... Perl calls the first one to get the unique ids and the timestamp ...
    (perl.dbi.users)