When I try to execute XML query using the ADO command object I receive error message that the syntax is not correct. This happens when I use the SQLOLEDB provider, but when I use the SQLXMLOLEDB provider I don't have any problems.

Please somebody explain this to me!!!