Can anyone simply tell me whether they are doing this - using XML data
types, or CLOBS, for fields in a database?  Judging by the lackof response,
maybe nobody is doing this successfully with ADO (not ADO.NET) and VB6.

Thanks,
PJ



"P James" <p.james@N...> wrote in message
news:ONfxlM6ZFHA.720@T......
>
>
> Can somebody share a code example showing how they handled getting at data
> from a field of type XML in Oracle through ADO?  And also what provider
> (connection string) they used?  My understanding is that it is stored as a
> CLOB in Oracle, behind the scenes, and that it can be gotten to via ADO
this
> way.  A code example would really help!
>
> Many thanks,
> PJ
>
>
>
>
>
>
> "Uwa Agbonile [MSFT]" <uwaag@o...> wrote in message
> news:OmwUX6uYFHA.1344@T......
> > There is no built in XML data type in ADO so how ADO sees or deals with
> this
> > type depends on the manner the type is surfaced by the underlying
> provider.
> > You would have to look at the underlying provider documentation to know
> > this.
> >
> > BTW, the Microsoft Oracle OLEDB Provider and ODBC driver that ships with
> > Windows Server 2003 does not provide native support for this type.
> >
> > -- 
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Regards,
> > Uwa Agbonile[MSFT]
> >
>
>
>
> "Andrew D. Newbould" <newsgroups@N...> wrote in message
> news:+Vr$zZHIj7lCFwNx@z......
> > With ADO 2.6 or 2.7 ...
> >
> > Use the Fields collection and look at the Type property. What is it ?
> >
> > Then check the DataTypeEnum values to work out how ADO is treating the
> > XML datatype. I would guess at one of the adVarChar types which means
> > you can treat it as just another string.
> >
> > -- 
> > Andrew D. Newbould                  E-Mail:
newsgroups@N...
> >
> > ZAD Software Systems                Web   :  www.zadsoft.com
>
>
>
> > In message <uESxkVsYFHA.3040@T...>, P James
> > <p.james@N...> writes
> > >
> > >Hi,
> > >
> > >Can anyone tell me if the native version of ADO that ships with Win
> Server
> > >2003 supports Oracle's XML data type?  I want to use an XML data type
> > >on a field in my database, and access it from VB6 via ADO, but I don't
> > >know where to begin.  Do I need a certain Oracle driver (or should I
say
> > >provider)?
> > >
> > >Many thanks,
> > >PJ
> > >
> >
>
>