Protocol error in TDS stream - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Protocol error in TDS stream

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-10-16 : 08:10:20

hello friends!

i am getting error while trransfering records from one server to another through DTS..two days back it was working fine but noe i am struck here..

OLEDB provider 'SQLOLEDB' reported an error.
OLE DB error trace [OLE/DB provider 'SQLOLEDB' IRowset :: GetNextRows returned 0x80004005: ].
[OLE/DB provider returned message: Protocol error in TDS stream]
[OLE/DB provider returned message: Timeout expired]

I am using

insert into tablename
select * from [srv1].[DB].[owner].table

T.I.A

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-16 : 08:38:13

What happened during the transfer with

1) The network?
2) The source machine?
3) The target machine?

Peter Larsson
Helsingborg, Sweden

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-10-16 : 08:46:54

I am getting this for the first time..i cant understand you....

T.I.A

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-16 : 08:49:23

Was there a power failure? Someone tripped and pulled a network cable?
The source machine suddenly started a defragmentation?
The target machine got its disk full?

Peter Larsson
Helsingborg, Sweden

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-10-16 : 09:11:07

hi

hope that will not cases as this source and destination server is on client side....but that really matter as now some DTS working fine but some DTS giving this error and now i got another error like

[DBNETLIB][ConnectionRead(recv()).]General network error.Check your network documentation.

T.I.A

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-16 : 09:13:23

There can be many sources for this.
Temporarily slow network, faulty nic drivers.

If you can, try to increase the command timeout period.

Peter Larsson
Helsingborg, Sweden

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-10-17 : 00:27:14

hello

...i am transfering data from one server to another but what i m struck is wheather i should use push connection or pull connection in DTS which one is better as performance i.e i use destination as connection or source as connection..in DTS

T.I.A

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-10-18 : 02:49:38

Hi
It seems like a network issue.I think your connection might have got disconnected.

Regards
Nitin

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources