Home > Protocol Error > Protocol Error In Tds Stream Excel

Protocol Error In Tds Stream Excel

Contents

You cannot edit HTML code. 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. And could you explain how to determine which drivers and how to reinstall them. Login. click site

For weeks we've just been running the thing manually, but that's not a solution, just a delay of the problem. Guessing this isn't so much of an issue in Excel 2007 upwards.JCEH Monday, September 26, 2016 3:58 PM Reply | Quote 0 Sign in to vote Incidentally, this also works in I corrected the problem by removing the connection and recreating it. I've removed the firewall as well. Check This Out

Protocol Error In Tds Stream Excel 2013

SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! However I've not found any that describe this error comming from Microsoft Excel and so I don't know how to resolve it. All Forums SQL Server 2000 Forums Import/Export (DTS) and Replication (2000) Protocol error in TDS stream Reply to Topic Printer Friendly Author Topic ZoneFX Starting Member United Kingdom 17 Posts It is now a multi-cloud world for most organizations.

  1. 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.
  2. You cannot rate topics.
  3. If the buffer is too large the driver may be screwing up packets.
  4. 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)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย
  5. what is default database connection methods in sql server 2000/2005?
  6. It is set up with an ODBC connection.
  7. You cannot post or upload images.
  8. I can import the view into Access and export to Excel, and I can link the view as a linked table in Access and export.
  9. can't find a solution online.
  10. ODBC is just not the way to go.gr.Armin Like Show 0 Likes (0) Actions Go to original post Actions Remove from profile Feature on your profile More Like This Retrieving data

WHen I use the ODBC connection I get an error from Excel: ODBC SQL Server driver: Protocol error in TDS stream. Oracle Database MS SQL Server Unix OS Basic Housekeeping for SQL Server Video by: Steve Via a live example, show how to setup several different housekeeping processes for a SQL Server. You cannot post replies to polls. Protocol Error In Tds Stream Sql Server 2008 R2 I think the issue is about the ODBC Drive.

Is this just a network traffic issue (I'm on a domestic 1 meg connection) or has my table got too big?I'm using SQL 2000 SP4 on Windows Server 2003 rmiao Flowing You cannot post JavaScript. 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, https://community.qlik.com/thread/142384 Data -> Connections -> Remove After recreating, rebinding it to my Pivot Table it corrected the issue.

Wednesday, January 08, 2014 4:50 PM Reply | Quote 0 Sign in to vote The SQL Server client drivers. Protocol Error In Tds Stream Sql Server 2012 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 Connect with top rated Experts 18 Experts available now in Live! You cannot edit your own events.

Protocol Error In Tds Stream Sql Server

Security! 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 Protocol Error In Tds Stream Excel 2013 You cannot delete other events. Protocol Error In Tds Stream Communication Link Failure You cannot edit other posts.

You cannot post new polls. http://spamdestructor.com/protocol-error/protocol-error-in-tds-stream-excel-2007.php It tends to get to about 70% complete before it fails. Thursday, January 09, 2014 9:54 AM Reply | Quote 0 Sign in to vote I have seen this where theserver doesn't respond in time, pulling data from SQL via ODBC using 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 Protocol Error In Tds Stream Ssis

Increasing the timeout period or taking the data direct from a table rather than through a view onto a table solves the issue. Join Now For immediate help use Live now! Proposed as answer by Papy NormandModerator Wednesday, January 23, 2013 1:07 PM Marked as answer by Iric WenModerator Friday, January 25, 2013 8:48 AM Thursday, January 17, 2013 2:34 PM Reply navigate to this website You cannot delete other posts.

You cannot edit your own topics. Protocol Error In Tds Stream Tableau 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 Privacy statement  © 2016 Microsoft.

Cause Excel does not get information about the linked server per se.

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 If so the fix is fairly simple: sp_configure 'remote query timeout (s)',3600

GO RECONFIGURE GO JCEH Monday, January 20, 2014 2:17 PM Reply | Quote 0 Sign in to vote However, Left by ENG. Protocol Error In Tds Stream Linked Server Monday, January 20, 2014 4:03 PM Reply | Quote 0 Sign in to vote This should also not raise a TDS protocol error.

Our new SQL Server Forums are live! Everything runs fine except on occation the DTS fails kicking up a "Protocol error in TDS stream" The table that fails has just about 11,000 rows. I found an article on the SQLTeam.com forums that helped get this working finally. my review here Username: Password: Save Password Forgot your Password?

I decided to investigate. You cannot upload attachments. If you have a large data set it times out. 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

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 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