none
Excel Query Error RRS feed

  • Question

  • Hi,

    I'm trying to pull back some (a lot of) data from a SQL Server 2005 instance using Excel 2003 and Microsoft Query. I think that the volume of data has grown to a size were something is failing as I now get the following error:

    [Microsoft][ODBC SQL Server driver]Protocol error in TDS stream

    Most of the articles i've read on line describe this as being a problem where the data packets sent via TCP/IP are split and start off as being syncronous but due to the delay become asyncronous. The switch and subsequent receipt of duplicate data throws this error. However I've not found any that describe this error comming from Microsoft Excel and so I don't know how to resolve it.

    I've noted that if I upgrade to Office 2007 and use the 'From SQL Server' option instead of 'Micorosft Query' that the results are returned successfully.

    Any suggestions on how I can resolve this error in Excel 2003?

    Thanks,

    Mike

    • Changed type renMike Wednesday, October 13, 2010 2:59 PM Wrong type
    Wednesday, October 13, 2010 2:53 PM

Answers

  • Hello Renmike,

    Excel 2007 is using a different SQL Server driver than MSQuery uses which is most likely accounting for the error.

    There is a fix for this issue located here: http://support.microsoft.com/kb/945892 and that KB Article references http://support.microsoft.com/kb/946608/LN/ - that article contains a fix at the top of the page. The problem is with the operating system and SQL Server, Please try applying that fix to your SQL Server machine and let me know if the problem is resolved.

    Will Buffington
    Microsoft Excel Support

    Thursday, October 14, 2010 4:25 PM
    Moderator

All replies