Geeks With Blogs

News INETA Community Speakers Program
GeeksWithBlogs.net: WTFNext's hosting!

View Stacy Vicknair's profile on LinkedIn


WTF Next? Dev ramblings from a master of nothing.

This tip might not fix everyone's issue, but for the problem I was facing today this worked out just fine.

We have a scheduled weekly DTS package that is failing for the reason specified in this title: "Protocol error in TDS stream". For weeks we've just been running the thing manually, but that's not a solution, just a delay of the problem. I decided to investigate.

I found an article on the SQLTeam.com forums that helped get this working finally. For us, all that was necessary was to switch the database connection to ODBC over OLE DB. For some reason the OLE DB driver wasn't enjoying the network traffic from the stored procedure the package was calling, or that would be my best guess.

Anyways, score one for having one less thing to waste time on.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95829

 

Posted on Monday, December 29, 2008 12:40 PM Other | Back to top


Comments on this post: SQL Server 2000 Tip - Protocol error in TDS stream

# re: SQL Server 2000 Tip - Protocol error in TDS stream
Requesting Gravatar...
It really Networka Problem,or you tables needs to re index
thanks.
Left by ENG. ABDIKARIIM on Dec 16, 2009 1:53 AM

Your comment:
 (will show your gravatar)


Copyright © Stacy Vicknair | Powered by: GeeksWithBlogs.net