Problem solve Get help with specific problems with your technologies, process and projects.

What databases are supported in SQLXML?

I attended your webcast on "XML for the Enterprise" but couldn't get the "Ask a Question" sub-window to receive my question. In your talk, you said that XML is increasing DB native support (e.g. SQLXML package). My question is, what specific databases are directly supported (not thru an external driver like ODBC) e.g. Oracle? SQLServer? mySQL?
Platform: Win2000, WinXP
SQLXML supports only SQLServer. SQLServer, Oracle and DB2 have native support for XML too, although I don't know what their APIs look like. Probably they would implement an ExecuteXmlReader method somehow. By native support I mean you can store XML in a single field, and have additional semantics on it, such as indexing, querying, well-formedness checks, and so on. The proposed ANSI SQL-2003 standard includes the XML datatype: http://www.wiscorp.com/sql/SQL2003Features.pdf. The way that native support is exposed through .NET APIs depends on the specific ADO.NET data provider. The SqlClient provider exposes the ExecuteXmlReader method I mentioned.

Dig Deeper on SQL Server and .NET development

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.