Odbc Sql Server Driver 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 Pro Discussions Question 0 Sign in to vote protocol error in tds stream excel 2013 Hi, I'm trying to pull back some (a lot of)data from a SQL
Protocol Error In Tds Stream Sql Server
Server 2005 instance using Excel 2003 and Microsoft Query. I think that the volume of data has grown to protocol error in tds stream sql server 2008 r2 a size were something is failing as I 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
Protocol Error In Tds Stream Communication Link Failure
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 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 odbc driver 11 for sql server]protocol error in tds stream 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, 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
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet https://social.technet.microsoft.com/Forums/office/en-US/280be6c5-eb04-4658-aa75-bd86a558c96c/excel-query-error?forum=excel Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/154295 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
SQL Server experts to answer whatever question you can come up with. Our new SQL Server http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94018 Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums Transact-SQL (2005) EXCEL Import Data Query Reply to Topic protocol error Printer Friendly Author Topic sureshkumarnaidu Starting Member 3 Posts Posted-12/11/2007: 06:35:53 Hi All,Iam trying to import data from Excel using Import Data query which has 125 columns. 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 protocol error in Knowledge South Africa 1466 Posts Posted-12/11/2007: 06:45:16 I think there is a limt of 25 columns when using this.Check this link: http://forums.aspfree.com/microsoft-sql-server-14/protocol-error-in-tds-stream-39882.htmlDuane. SwePeso Patron Saint of Lost Yaks Sweden 30421 Posts Posted-12/11/2007: 06:46:02 This is a forum for WORKING scripts only.Your problem is described herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926even though the header says "Export".E 12°55'05.25"N 56°04'39.16" Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS