Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great 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 | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Protocol error in TDS stream
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ZoneFX
Starting Member

United Kingdom
17 Posts

Posted - 01/20/2008 :  06:41:05  Show Profile  Reply with Quote
I have a DTS set up that copies data across from the live server to a local "backup/development" copy. 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. It tends to get to about 70% complete before it fails. 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 Fount of Yak Knowledge

USA
7266 Posts

Posted - 01/20/2008 :  20:20:36  Show Profile  Reply with Quote
Most likely.
Go to Top of Page

ZoneFX
Starting Member

United Kingdom
17 Posts

Posted - 01/31/2008 :  12:49:02  Show Profile  Reply with Quote
Most likely which?

Network or too big?
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 01/31/2008 :  13:54:55  Show Profile  Reply with Quote
it could be a problem with the OLE db provider.



Check this KB article for a hotfix for OLEDB provider regarding this error http://support.microsoft.com/default.aspx/kb/890759

Also, have you tried reconfiguring your connection to use ODBC driver instead? it will be slower, but if it works then that points to a problem with OLE DB provider.

I would try the hotfix, if it still doesn't work properly then try using the ODBC.



-ec
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 02/01/2008 :  00:08:34  Show Profile  Reply with Quote
>> Network or too big?

They are related, transferring big table over slow network will cause problem.
Go to Top of Page

BigRig2112
Starting Member

USA
1 Posts

Posted - 08/05/2010 :  11:02:02  Show Profile  Reply with Quote
It may be more of an issue with the version of Excel you're using as well.
I received this error using MS Excel 2007. I looked at the connection properties and un-checked the option of "Enable Background Refresh" and it resolved the issue.

The Hotfix from MS, had some ugly instructions of backing up the machines system before installing the Hotfix. I decided to try and reduce the query time and found the Refresh Options.

Hope this helps someone.


Have A Blessed Day..!

Big Rig
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000