Hi gurus,
We are using Link server (CA driver) to connect to IDMS Mainframe from SQL
server . Currently we in transition to replace IDMS with DB2.
I am been able to setup Link servers using two products: IBM DB2 Connect and
Microsoft Host Integration server. Both works.
Does anybody can provide me with cons and pros why I have to pick one over
another ?

Your responds is very appreciated.

Stan
-----Original Message-----
From: (Keif Gwinn)
[mailto:mssqldba-ezmlmshield-x55706883.[Email address protected]
Sent: Wednesday, March 23, 2005 7:52 AM
To: LazyDBA Discussion
Subject: Re: Network Error ?


> Can anybody shed any light on the following error on connecting to the
> database (SQL 2000):
>
> protocol error in TDS stream

We had this the other day, it turned out to be 10-15% packetloss that was
causing it.

ping -f -l 1440 sqlserverip

from the connecting machine should show you if there is packet loss on
larger packets than a normal ping.

-
Keif


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page