Sql Server 2005, Xml types, and ODBC?

Question

Can a Sql 2005 database that uses the xml type be accessed with ODBC?

Answer 1

Not sure if this is true for all ODBC drivers connecting to SQL Server 2005, but DataDirect does claim to support pretty much all SQL Server 2005 and even most of the new SQL Server 2008 features. See their listing here.

Ah, and here's Microsoft comment on it:

If you are developing a COM-based application and need to access the new features of SQL Server 2005, you should use SQL Native Client. If you don't need access to the new features of SQL Server 2005, you can continue to use Microsoft Data Access Components (MDAC).

So I guess, if you use the SQL Native Client ODBC driver, you should be able to use the XML data type.

Marc

Answer 2

Hi scaffman,

I believe XML datatypes will be, pretty much, handled as character data types...

Certainly, the OpenLink ODBC driver returns XML data types, locally, as SQL_LONGVARCHAR.

I hope this helps..

Regards,

Garry M. Biggs Technical Support OpenLink Software http://www.openlinksw.com