Protocol Error In Tds Stream Excel 2007
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Protocol Error In TDS Stream SQL Server > SQL Server Data Access Question 0 Sign protocol error in tds stream communication link failure in to vote I have a client workstation trying to pull data from
Protocol Error In Tds Stream Sql Server 2008 R2
a SQL 2012 server. It is set up with an ODBC connection. An error is encounter while the report is
Odbc Driver 11 For Sql Server Protocol Error In Tds Stream
pulling the data. 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. I've removed the firewall as well. I tried updating the native client driver. I don't know what else to try. Thursday, January 17, 2013 2:30 PM Reply | Quote Answers 0 Sign in to vote TDS stream errors indicate either corrupted driver installations or severe physical network error. So when you have already done a clean reinstall of the driver, I would take a look at the network hardware. If only on client has the problem try changing the NIC or wires.. 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 | Quote All replies 0 Sign in to vote TDS stream errors indicate either corrupted driver installations or severe physical network error. So when you have already done a clean reinstall of the driver, I would take a look at the network hardware. If only on client has the problem try changing the NIC or wires.. 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 | Quote 0 Sign in to vote Which drivers - on the Server itself? And could you explain how to determine which drivers and how to reinstall them. Thanks. Wednesday, January 08, 2014 4:50 PM Reply | Quote 0 Sign in to vote The SQL Server client drivers. Run odbcad32 on the command line. See the drivers page for installed drivers. For re
SQL Server experts to answer whatever question you can come up with. Our new SQL Server 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 Printer Friendly Author Topic https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a68b2f5-a033-44a5-ab1b-ec76967ebfd4/protocol-error-in-tds-stream?forum=sqldataaccess 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 Knowledge South Africa 1466 Posts http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94018 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 and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analy
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 https://community.qlik.com/thread/142384 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 http://forums.devart.com/viewtopic.php?t=12863 it fails giving the following Error:SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS streamSQL SELECT * FROM AirReconLive.dbo."tbl_SalesHeader"2nd time when I reload it , it Succeeds without giving any error.Please help protocol error !!!!RegardsErika 3917Views 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) 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 protocol error in 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 (0) Actions Re: Protocol Error in TDS Stream Armin Oct 2, 2015 9:49 AM (in response to Bruno Garcia) Hi,Updated the driver, but no succes... It keeps giving the same error.SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS streamWith the Debugger on it gives a little bit
• Page 1 of 1 Protocol error in TDS stream by mig229 » Thu 11 Sep 2008 13:30 Hi, I have a problem. I migrate from 2000 to 2005 ms sql server. Client application write on Delphi 7 Enterprise and use SDAC 3.80. When i run an application i have error message "protocol error in tds stream". I download sdac 4.5 trial, but the problem is not disappear. ms sql server version - Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) mig229 Posts: 3Joined: Thu 11 Sep 2008 13:07 Top by Dimon » Thu 11 Sep 2008 15:52 Please, check that the MSConnection.Options.Provider property is set to prAuto. Dimon Devart Team Posts: 2883Joined: Mon 05 Mar 2007 16:32 Top by mig229 » Fri 12 Sep 2008 06:52 When I set MSConnection.Options.Provider property to prAuto I have error message "communication link failure" mig229 Posts: 3Joined: Thu 11 Sep 2008 13:07 Top by Dimon » Mon 15 Sep 2008 07:55 SDAC requires OLE DB installed on workstation. Please check if you can to connect to MS SQL server 2005 using MS SQL Server Management Studio. Dimon Devart Team Posts: 2883Joined: Mon 05 Mar 2007 16:32 Top by mig229 » Mon 15 Sep 2008 08:35 I can connect to MS SQL using Managment Studio. mig229 Posts: 3Joined: Thu 11 Sep 2008 13:07 Top by Dimon » Tue 16 Sep 2008 11:29 Please give a more detailed description of the problem. What provider do you use? Try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com. Dimon Devart Team Posts: 2883Joined: Mon 05 Mar 2007 16:32 Top Protocol error in TDS stream by Vladimir » Tue 30 Sep 2008 16:14 If you profile, you will notice that prior to whatever SQL statement you execute that causes error, you will see SET NO_BROWSETABLE ON some other SQL here. try to paste