ADO & XML Data type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

P James - 27 May 2005 13:57 GMT

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 in my
data type but I don't know where to begin. Do I need a certain Oracle
driver (or should I say provider)?

Many thanks,
PJ

Reply to this Message

Uwa Agbonile [MSFT] - 27 May 2005 20:02 GMT

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.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Uwa Agbonile[MSFT]

> Hi,
>
[quoted text clipped - 5 lines]
> Many thanks,
> PJ

Reply to this Message

VB Forum / Database Access / May 2005

ADO & XML Data type