Excel Sql Protocol Error In Tds Stream
Contents |
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Excel Query Error Microsoft Office > Excel IT
Microsoft Odbc Sql Server Driver Protocol Error In Tds Stream Excel
Pro Discussions Question 0 Sign in to vote Hi, I'm trying to protocol error in tds stream sql server 2012 pull back some (a lot of)data from a SQL Server 2005 instance using Excel 2003 and Microsoft protocol error in tds stream sql server 2008 r2 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
Protocol Error In Tds Stream Excel 2010
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
Protocol Error In Tds Stream Ssis
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 Reply | Quote Answers 0 Sign in to vote 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/945892and 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 Marked as answer by Jennifer ZhanModerator Thursday, Oct
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » General » Protocol error in TDS stream Protocol error in protocol error in tds stream communication link failure TDS stream Rate Topic Display Mode Topic Options Author Message melthedbamelthedba Posted Wednesday, December 4,
Protocol Error In Tds Stream Excel 2013
2002 7:30 AM Old Hand Group: General Forum Members Last Login: Friday, September 30, 2016 12:40 PM Points: 310, Visits: 149 Hello,Recently, protocol error in tds stream sql server I began receiving error messages while connecting to a server via Query Analyzer and running sp_helptext, for instance. I received the below error on numerous occasions:[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream[Microsoft][ODBC SQL Server Driver]Protocol https://social.technet.microsoft.com/Forums/office/en-US/280be6c5-eb04-4658-aa75-bd86a558c96c/excel-query-error?forum=excel error in TDS stream[Microsoft][ODBC SQL Server Driver]TDS buffer length too large[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL ServerDoes anyone have a reason for this error and a fix? I've been searching the web and already updated MDAC to 2.7 but still the error persists. Other than MDAC, I haven't seen any other resolution suggested for the problem.Thank you so much,Melanie Post #8585 Antares686Antares686 Posted http://www.sqlservercentral.com/Forums/Topic8585-9-1.aspx Saturday, December 7, 2002 10:08 PM SSCrazy Eights Group: Moderators Last Login: Monday, May 16, 2016 7:45 AM Points: 8,376, Visits: 780 Try reinstalling your NIC drivers. If the buffer is too large the driver may be screwing up packets. Might be server side or client side. ALso, as you stated you did MDAC 2.7 make sure both client and server. Post #48551 melthedbamelthedba Posted Monday, December 9, 2002 6:27 AM Old Hand Group: General Forum Members Last Login: Friday, September 30, 2016 12:40 PM Points: 310, Visits: 149 Hello Antares686,Thank you very much for your recommendation. I'll try this and let you know how it goes.Melanie Post #48552 melthedbamelthedba Posted Tuesday, December 17, 2002 12:22 PM Old Hand Group: General Forum Members Last Login: Friday, September 30, 2016 12:40 PM Points: 310, Visits: 149 Hello,Well, our network guy decided to defrag all of our systems and so far we haven't experienced any TDS errors again... and hope we never do. We did not update MDAC nor touch the NIC cards.Thanks,Melanie Post #48553 JonrJonr Posted Wednesday, January 26, 2005 5:22 AM SSC-Enthusiastic Group: General Forum Members Last Login: Friday, June 19, 2015 7:41 AM Points: 142, Visits: 65
Just as a follow up to this, we saw the same problem on a brand new, 4 processor HP server.for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a https://www.experts-exchange.com/questions/23307846/When-iam-executing-query-iam-getting-this-error.html Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > When iam executing query iam getting this error Want to Advertise Here? Solved When iam executing query iam getting this error Posted on 2008-04-09 MS SQL Server Databases MS SQL Server 2005 3 protocol error Verified Solutions 6 Comments 1,767 Views Last Modified: 2008-09-13 When ever iam executing a query in query analyser i get this error earlier it was working fine now this err is seen. what is default database connection methods in sql server 2000/2005? Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]Protocol error in protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream [Microsoft][ODBC SQL Server Driver]TDS buffer length too large [Microsoft][ODBC SQL Server Driver]TDS buffer length too large [Microsoft][ODBC SQL Server Driver]TDS buffer length too large [Microsoft][ODBC SQL Server Driver]TDS buffer length too large [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server [Microsoft][ODBC SQL Server Driver]TDS buffer length too large [Microsoft][ODBC SQL Server Driver]TDS buffer length too large [Microsoft][ODBC SQL Server Driver]TDS buffer length too large 0 Question by:Sandeepiii Facebook Twitter LinkedIn Google LVL 75 Active today Best Solution byAneesh Retnakaran open a new Query analyser and run that query Go to Solution 4 Comments LVL 75 Overall: Level 75 MS SQL Server 59 MS SQL Server 2005 45 Databases 22 Message Active today Acce