I have had this issue occur and even set fmtonly off and set nocount on didnt fix it. The only solution was to change the data source to an ADO...