The SQL native client is contained in a single dynamic link library and supports both OLEDB and ODBC interfaces. However the names of these
interfaces are different from those used in MDAC. The SQL Native Client supports the For XML clauses in the queries as well as the XML data type.
Click here for more...!