Get this weird error when trying to subscribe to a publication

Hey. The subscriber is a SQL 2000 server. It's exactly the same as the
publisher in configuration. I sp_dropsubscriber the subscriber and readded it
from EM but i still get this error. I disabled publishing and everything but
it still gives me this error.
14095, 16, Could not subscribe to publication '%s' because heterogeneous
Subscriber '%s' only supports the @.sync_method parameter value 'bcp
character'
How do I fix this error? Thank you very much
Tej.
Query sysservers in master to verify that this subscriber is configured as a
SQL Server. If not drop it and recreate it. You will need to remove it from
the linked servers and remote servers collections.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tejas Parikh" <TejasParikh@.discussions.microsoft.com> wrote in message
news:7F33254C-F4D4-42D9-85D5-B32E3DB7AF12@.microsoft.com...
> Hey. The subscriber is a SQL 2000 server. It's exactly the same as the
> publisher in configuration. I sp_dropsubscriber the subscriber and readded
> it
> from EM but i still get this error. I disabled publishing and everything
> but
> it still gives me this error.
>
> 14095, 16, Could not subscribe to publication '%s' because heterogeneous
> Subscriber '%s' only supports the @.sync_method parameter value 'bcp
> character'
>
> How do I fix this error? Thank you very much
> Tej.