Re: Getting date/time fields from Oracle with ADO

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Douglas Marquardt (no_spam_at_dummy.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 12:08:41 -0700

Hi Cesar:

Yes, ado will report 135 for a date field in Oracle.

The reason I asked, is because I was having the same problem
and I discovered that my field was set to timestamp; when I
changed it to data the error went away.

Do you create the table using SQL (i.e. CREAT TABLE ..etc)
or did you do it manually in the OEM?

Doug.

"Cesar Ronchese" <ronchese@smlinfo.com.br> wrote in message news:uyIx$ggBEHA.392@TK2MSFTNGP12.phx.gbl...
> 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: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ... You should really only do this at design-time, or with a command you will ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Table open times and rowsize discontinuity
    ... some manner related to ADO or the tool you are using. ... Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text - ... For the array fetching, the only parameter I can find in the ADO ... exceeding the SDU and the MTU. ...
    (comp.databases.oracle.misc)
  • Re: OO4O 2.1 vs MDAC
    ... We're planning to move VB3 using OO4O 2.1 ... Now I must distinguish and list out some of the features that ADO / ... (OLE DB or ODBC) ... Also you don't mention the Oracle version there are differences between ...
    (microsoft.public.data.ado)
  • Re: Stored procedures unter Windows XP mit Oracle ODBC Treiber 10.01.0
    ... mit jeder ORACLE Clientversion wird automatisch ein ORACLE ODBC-Treiber ... Über ADO kannst Du das nicht beeinflussen. ... > Public Function StartePruefung(ByRef s_GeVoNr As String, ... > Dim prmGeVoNr As ADODB.Parameter ...
    (microsoft.public.de.vb.datenbank)