Home > Protocol Error > Protocol Error In Tds Stream Excel

Protocol Error In Tds Stream Excel

Contents

All rights reserved.Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback TechNet Products IT Resources Downloads Training Support Products Windows Windows Server System Center Browser   Office Office 365 Exchange Server   SQL Server We are using SQL Server 2000 + SP3(8.00.847) but I am not able to find any fix that is related to the problem.Post by Kevin McDonnell [MSFT]It could be a bug, 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. Will Buffington Microsoft Excel Support Marked as answer by Jennifer ZhanModerator Thursday, October 21, 2010 5:22 AM Thursday, October 14, 2010 4:25 PM Reply | Quote Moderator 0 Sign in to have a peek at this web-site

Privacy statement  © 2016 Microsoft. I looked at the connection properties and un-checked the option of "Enable Background Refresh" and it resolved the issue.The Hotfix from MS, had some ugly instructions of backing up the machines You cannot edit other posts. You cannot post JavaScript. https://social.technet.microsoft.com/Forums/office/en-US/280be6c5-eb04-4658-aa75-bd86a558c96c/excel-query-error?forum=excel

Protocol Error In Tds Stream Excel 2013

Gavin Chan 2005-03-18 01:47:02 UTC PermalinkRaw Message Do you mean that query the server locally by ms excel and msquery? From looking at other postings, is this a SQL Server 2000 or ODBC bug, or do I need to update drivers [which one(s)]? -- Dennis dennis bˬ*h(~( sponsored links Anyways, score one for having one less thing to waste time on. Join our community for more solutions or to ask questions.

  1. I can export from SQL Server into Excel through DTS and the spreadsheet works fine.
  2. Like the replies above it is an ODBC driver issue.
  3. Come on over!
  4. Connect with top rated Experts 18 Experts available now in Live!
  5. Mein KontoSucheMapsYouTubePlayNewsGmailDriveKalenderGoogle+ÜbersetzerFotosMehrShoppingWalletDocsBooksBloggerKontakteHangoutsNoch mehr von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
  6. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic… Concerto Cloud Services The world is on the move: Electronic commerce to Connected commerce Article by:

Join the community of 500,000 technology professionals and ask your questions. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? JJCEH Monday, January 20, 2014 2:20 PM Reply | Quote 0 Sign in to vote A query timeout should never raise a TDS protocol error. Protocol Error In Tds Stream Sql Server 2008 R2 If this is abug, it seems to be related to SQL Server.

ALso, as you stated you did MDAC 2.7 make sure both client and server. Protocol Error In Tds Stream Sql Server You cannot post events. You cannot edit other events. From myunderstanding, I would think that if something is too large for a singlenetwork packet, it will just be broken into smaller pieces and that should betransparent to the application.

Like Show 1 Like (1) Actions Re: Protocol Error in TDS Stream Stephane Chivet Jan 14, 2015 5:37 AM (in response to Erika Jain ) Hi Erika,I had exactly the same Protocol Error In Tds Stream Sql Server 2012 Name: *And who are you? There is a fix for this issue located here: http://support.microsoft.com/kb/945892and that KB Article references http://support.microsoft.com/kb/946608/LN/- that article contains a fix at the top of the page. You cannot delete other events.

Protocol Error In Tds Stream Sql Server

Sometimes it would bomb out with:[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server[Microsoft][ODBC SQL Server Driver]TDS buffer length too large(repeated 3x)Running either query locally returned the data immediately, so we If you have a large data set it times out. Protocol Error In Tds Stream Excel 2013 You may read topics. Protocol Error In Tds Stream Communication Link Failure You cannot post replies to polls.

This focused our attention on the network connection.Eventually our resident network expert took a look at the pair of network cards and noticed a very large number of transmit errors in Check This Out 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. Cause Excel does not get information about the linked server per se. Other Nuget for SharpBox Other Introduction Other Comments on this post: SQL Server 2000 Tip - Protocol error in TDS stream # re: SQL Server 2000 Tip - Protocol error in Protocol Error In Tds Stream Ssis

You cannot post HTML code. what is default database connection methods in sql server 2000/2005? We've got lots of great SQL Server experts to answer whatever question you can come up with. http://caribtechsxm.com/protocol-error/protocol-error-in-tds-stream-excel-2010.php Close down Query analyser, or close current window and re-connect, and then open up a new query window and try agian. 0 Message Author Comment by:Sandeepiii2008-04-09 ok let me try

All rights reserved.Terms of Use|Trademarks|Privacy Statement|Site Feedback Log inVisit Qlik.comHomeContentPeoplePlacesLinksQlik SenseQlikViewBlogsGroupsBeta ProgramsSearch All Places > QlikView Forums & Resources > QlikView App Development > Discussions Please enter a title. Protocol Error In Tds Stream Tableau Join & Ask a Question Need Help in Real-Time? I decided to investigate.

It keeps giving the same error.SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS streamWith the Debugger on it gives a little bit more information, SQL##f

We dare not to apply this on production as we are afraid ofthe possible side effect.Is this a bug in MS Query, Excel or SQL Server and is there any betterworkaround Please enter a comment.Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code Verification: Copyright © Stacy Vicknair | Powered by: GeeksWithBlogs.net | Join free Popular Posts on Geeks All Rights Reserved. Protocol Error In Tds Stream Linked Server Other than MDAC, I haven't seen any other resolution suggested for the problem.Thank you so much,Melanie Post #8585 Antares686Antares686 Posted Saturday, December 7, 2002 10:08 PM SSCrazy Eights Group: Moderators Last

Geeks With Blogs Geeks with Blogs, the #1 blog community for IT Pros Start Your Blog Login Stacy Vicknair 136 Posts | 109 Comments My Other Recent Posts How to access Edited by Stefan HoffmannMVP Monday, September 26, 2016 5:01 PM Monday, September 26, 2016 5:01 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Try to connect using OLEDB direclty.This solved my problem.See ya! http://caribtechsxm.com/protocol-error/protocol-error-in-tds-stream-excel-2003.php http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95829   Technorati Tags: SQL Server 2000,Protocol error in TDS stream Posted on Monday, December 29, 2008 12:40 PM Other | Back to top Related Posts on Geeks With Blogs Matching

Given the mix up in ODBC drivers between 32bit and 64bit it should come as no surprise that it caused a hissy fit. Like Show 0 Likes (0) Actions Re: Protocol Error in TDS Stream Armin Oct 5, 2015 3:08 AM (in response to Armin ) Hi,I've been fiddling with this the rest of Thanks.