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

Protocol Error In Tds Stream Excel Odbc

Contents

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 what is default database connection methods in sql server 2000/2005? You cannot post new polls. Join & Ask a Question Need Help in Real-Time? click site

iam getting an error message"microsoft ODBC SQL Server Driver Protocol error in TDS Stream"Pls help meUrgentAdvances thanksRegardsSuresh Edited by - spirit1 on 12/11/2007 07:44:04 ditch Flowing Fount of Yak Knowledge South You cannot delete your own topics. If only on client has the problem try changing the NIC or wires.. Connect with top rated Experts 18 Experts available now in Live! check my site

Protocol Error In Tds Stream Excel 2013

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 You cannot vote within polls. 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, You cannot edit your own posts.

  • 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
  • You cannot send emails.
  • 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
  • Like Show 0 Likes (0) 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
  • However, if we are using query analyzer, this problem didnot occur.We can simulate the same problem with Excel 2000, XP and 2003.
  • Name: *And who are you?
  • You cannot delete other topics.
  • So when you have already done a clean reinstall of the driver, I would take a look at the network hardware.
  • One instance was pulling from Excel via ODBC to a 64bit instance that linked through to a 32bit instance.
  • You cannot edit HTML code.

Why the convoluted route to the data? 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 You cannot edit other events. Odbc Driver 11 For Sql Server]protocol Error In Tds Stream 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

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 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. You cannot delete your own posts. Our new SQL Server Forums are live!

and hope we never do. 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 So, update the ODBC Driver to the Latest one and it should help... Tighten space to use less pages.

Excel Odbc Sql Server Driver Protocol Error In Tds Stream

I don't know what else to try. http://www.sqlservercentral.com/Forums/Topic8585-9-1.aspx Username: Password: Save Password Forgot your Password? Protocol Error In Tds Stream Excel 2013 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 Protocol Error In Tds Stream Sql Server 2008 R2 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

We've got lots of great SQL Server experts to answer whatever question you can come up with. get redirected here You cannot send private messages. Join the community of 500,000 technology professionals and ask your questions. I decided to investigate. Protocol Error In Tds Stream Communication Link Failure

I corrected the problem by removing the connection and recreating it. If this is abug, it seems to be related to SQL Server. Doing very simple remote select queries on it from another box took 1+ minute to return1000 rows, over an hour to handle a 78,000 row table. navigate to this website 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

You cannot delete other posts. You cannot post EmotIcons. We didn'ttry that before.

I found an article on the SQLTeam.com forums that helped get this working finally.

For reinstalling the drivers: Installing SQL Server Native Client and Microsoft SQLNCli team blog. Could be a memory constraint for the application (or more likely the Microsoft Query 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 Suggested Solutions Title # Comments Views Activity sql2012 extended procedure in Master database 4 28 12d I backed up an OLD windows 2003 server that runs SQL with Windows Backup.

You cannot post or upload images. Wednesday, January 08, 2014 4:50 PM Reply | Quote 0 Sign in to vote The SQL Server client drivers. 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 http://spamdestructor.com/protocol-error/protocol-error-in-tds-stream-excel-2007.php 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.

The view runs correctly in Enterprise Manager. If this is abug, it seems to be related to SQL Server. Monday, January 20, 2014 4:03 PM Reply | Quote 0 Sign in to vote This should also not raise a TDS protocol error. Thanks.

TechCenter   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)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)  Home20132010Other VersionsLibraryForumsGallery Ask Report Abuse. Copyright © 2002-2016 Simple Talk Publishing. MS SQL Server Polish Reports in Access Video by: crystal Polish reports in Access so they look terrific.

Join our community for more solutions or to ask questions. can't find a solution online. 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 Go to Page...

Unit Testing Role-based Authorization in ASP.NET MVC 3 SharePoint 2007 / 2010 Content Indexing “The file reached the maximum download limit. Microsoft said that a fix will be available in next version of Windows....Post by Gavin ChanDo you mean that query the server locally by ms excel and msquery? Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room. I don't know about should, only what is.

For weeks we've just been running the thing manually, but that's not a solution, just a delay of the problem. ALso, as you stated you did MDAC 2.7 make sure both client and server. I've removed the firewall as well.