Home > Protocol Error > Protocol Error In Tds Stream Excel Odbc

Protocol Error In Tds Stream Excel Odbc

Contents

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, SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! I think the issue is about the ODBC Drive. If this is abug, it seems to be related to SQL Server. have a peek at this web-site

Try Free For 30 Days Join & Write a Comment Already a member? ABDIKARIIM on Dec 16, 2009 1:53 AM Your comment: Title: *So what is this about? Microsoft Customer Support Microsoft Community Forums SQL Server Developer Center   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย Connect with top rated Experts 18 Experts available now in Live! 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

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 An error is encounter while the report is pulling the data. 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

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. Privacy statement  © 2016 Microsoft. Join & Ask a Question Need Help in Real-Time? Odbc Driver 11 For Sql Server]protocol Error In Tds Stream 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

You cannot post new polls. Excel Odbc Sql Server Driver Protocol Error In Tds Stream I found an article on the SQLTeam.com forums that helped get this working finally. So, update the ODBC Driver to the Latest one and it should help... 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

Run odbcad32 on the command line. We didn'ttry that before. Like the replies above it is an ODBC driver issue. Email: (never displayed)*Email is optional, but if you enter one at least make sure it is valid. (will show your gravatar) Comment: *I do want to hear your thoughts.

Excel Odbc Sql Server Driver Protocol Error In Tds Stream

You cannot send emails. click for more info Database Connector Error: 'HY000:[Microsoft][SQL Native Client 11.0] Protocol error in TDS stream' I figured the issue was with the ODBC connection so I dropped and re-created it but the error persisted. Protocol Error In Tds Stream Excel 2013 We later found that this occurs whenthe user select too many fields from the MS Query Designer.Interestingly, we later found that this can be fixed by enlarging the'Network Packet Size' configuration Protocol Error In Tds Stream Sql Server 2008 R2 Data -> Connections -> Remove After recreating, rebinding it to my Pivot Table it corrected the issue.

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. http://caribtechsxm.com/protocol-error/protocol-error-in-tds-stream-excel-2010.php You cannot delete your own topics. We've restricted the ability to create new threads on these forums. I don't know what else to try. Protocol Error In Tds Stream Communication Link Failure

  1. Gavin Chan 2005-05-03 10:52:04 UTC PermalinkRaw Message We reported this problem and finally we confirmed that it is a bug.For MSQuery, ODBC driver is used which has a problem in retrieving
  2. Dev ramblings from a master of nothing. << 25% off plus free second shot on 070-536 | Home | .NET Tip: Char.IsDigit revisited >> SQL Server 2000 Tip - Protocol error
  3. Username: Password: Save Password Forgot your Password?
  4. Privacy Policy Site Map Support Terms of Use microsoft.public.sqlserver.connect Discussion: Protocol Error in TDS Stream vs Network Packet Size (too old to reply) Gavin Chan 2005-03-16 02:51:02 UTC PermalinkRaw Message We
  5. WHen I use the ODBC connection I get an error from Excel: ODBC SQL Server driver: Protocol error in TDS stream.
  6. Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us

Join our community for more solutions or to ask questions. You cannot edit your own posts. You cannot post or upload images. http://caribtechsxm.com/protocol-error/protocol-error-in-tds-stream-excel-2003.php Given the mix up in ODBC drivers between 32bit and 64bit it should come as no surprise that it caused a hissy fit.

For some reason the OLE DB driver wasn't enjoying the network traffic from the stored procedure the package was calling, or that would be my best guess. Might be server side or client side. Usually, rerunning the query doesn't work.

Join Now For immediate help use Live now!

However, if we are using query analyzer, this problem didnot occur.We can simulate the same problem with Excel 2000, XP and 2003. 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 SectionsHome PageQlikView ForumsQlik Sense ForumGroupsBlogsBlogsBusiness DiscoveryQlik DesignCommunity Manager BlogQlik Support UpdatesTechnical BulletinAll BlogsQlik SitesQlik.comPartner PortalCustomer PortalQlik MarketDemosTrademarksPrivacyTerms of UseCopyright © 1993–2016 QlikTech International AB, All Rights Reserved. All Forums SQL Server 2005 Forums Transact-SQL (2005) EXCEL Import Data Query Reply to Topic Printer Friendly Author Topic sureshkumarnaidu Starting Member 3 Posts Posted-12/11/2007: 06:35:53 Hi All,Iam

Get the crispest, clearest audio powered by Dolby Voice in every meeting. Monday, February 17, 2014 3:11 PM Reply | Quote 0 Sign in to vote Cross reference https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a68b2f5-a033-44a5-ab1b-ec76967ebfd4/protocol-error-in-tds-stream?forum=sqldataaccess&prof=requiredJCEH Monday, September 26, 2016 3:59 PM Reply | Quote Microsoft is conducting an online If only on client has the problem try changing the NIC or wires.. have a peek here Privacy Policy.