[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Ser

[emadhu26]

Hello All
Am trying to execute the following SQL
on NorthWind database ( SQL Server 2000)
SELECT *
FROM CUstomers for XML AUTO

the table has 91 records, but the sql above returns less
then 10 records and has the following exception
[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server


Can somebody explain why am not able to see all the 91 records in XML

thanks

 

[SmileyConspiracy]

Have just had a similar problem with a very different query. We found the problem only occurred where service pack 3 hadn’t been installed on the client. Hope this helps.