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
> >
>