Protocol Error In Tds Stream Excel Odbc
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 Pro Discussions Question 0 Sign in to vote Hi, I'm trying to pull protocol error in tds stream excel 2013 back some (a lot of)data from a SQL Server 2005 instance using Excel 2003
Excel Odbc Sql Server Driver Protocol Error In Tds Stream
and Microsoft Query. I think that the volume of data has grown to a size were something is failing as I protocol error in tds stream sql server 2008 r2 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
Protocol Error In Tds Stream Communication Link Failure
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 odbc driver 11 for sql server]protocol error in tds stream 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, October 21, 2010 5:22 AM Thursday, October 14, 2010 4:25 PM Reply | Quote Moderator All replies 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
type your message and try again. 7 Replies Latest reply: Oct 5, 2015 3:08 AM by Protocol Error in TDS Stream Erika Jain Nov 17, 2014 4:59 AM Hi All,I Have upgraded my Qlikview server and Desktop from Version Qv 11 Sr 2 to Qv 11 Sr 9.After this change some of my reloads of Application are failing from QMC at Stage1 (which means When I am fetching the data from Database SQL).When I am Trying to fetch the data 1st time it fails giving the following Error:SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS streamSQL https://social.technet.microsoft.com/Forums/office/en-US/280be6c5-eb04-4658-aa75-bd86a558c96c/excel-query-error?forum=excel SELECT * FROM AirReconLive.dbo."tbl_SalesHeader"2nd time when I reload it , it Succeeds without giving any error.Please help !!!!RegardsErika 3912Views Tags: none (add) This content has been marked as final. Show 7 replies Re: Protocol Error in TDS Stream Sai Maguluri Nov 17, 2014 12:51 PM (in response to Erika Jain ) Hi,I got the similar issue here and will investigate further... Like Show 0 Likes (0) https://community.qlik.com/thread/142384 Actions Re: Protocol Error in TDS Stream Sai Maguluri Nov 17, 2014 4:23 PM (in response to Erika Jain ) Hi,This is what I heard from Qlik Support below. So, update the ODBC Driver to the Latest one and it should help... Like Show 0 Likes (0) Actions Re: Protocol Error in TDS Stream Jared Papador Nov 17, 2014 4:29 PM (in response to Erika Jain ) This issue is really annoying. Like the replies above it is an ODBC driver issue. Try updating the driver or connecting via OLEDB and see if the issue persists. 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 problem. Now I have updated the ODBC Driver and it work as before: Like Show 0 Likes (0) Actions Re: Protocol Error in TDS Stream Bruno Garcia Jan 14, 2015 5:44 AM (in response to Erika Jain ) Hi friend.I had the same problem. I think the issue is about the ODBC Drive. Try to connect using OLEDB direclty.This solved my problem.See ya! Like Show 0 Likes (
up Recent PostsRecent Posts Popular TopicsPopular Topics http://www.sqlservercentral.com/Forums/Topic8585-9-1.aspx Home Search Members Calendar Who's On Home » SQL Server https://www.experts-exchange.com/questions/23307846/When-iam-executing-query-iam-getting-this-error.html 7,2000 » General » Protocol error in TDS stream Protocol error in TDS stream Rate Topic Display Mode Topic Options Author Message melthedbamelthedba Posted Wednesday, December 4, 2002 7:30 AM Old Hand Group: General Forum Members Last Login: Tuesday, October 18, 2016 protocol error 1:48 PM Points: 310, Visits: 150 Hello,Recently, 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 error in TDS stream[Microsoft][ODBC SQL Server Driver]TDS buffer length too protocol error in 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 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: Tuesday, October 18, 2016 1:48 PM Points: 310, Visits: 150 Hello Antares686,Thank you very m
a Question Ask 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 Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing 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 Verified Solutions 6 Comments 1,775 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 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 D