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
 Import/Export (DTS) and Replication (2000)
 Merge REplication problems

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-11-12 : 08:01:04
sandeep writes "Hi,

I am using merge replication in sql server professional edition.
While creating a snapshot at the subscripber i get the following error details of the Merge Agent.

Error Message: The process could not deliver the snapshot to the Subscriber.

Error details: The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
---------------------------------------------------------------------------------------------------------------
The process could not bulk copy into table '"dbo"."TradesCNSE"'.
(Source: COM10 (Agent); Error number: 20037)
---------------------------------------------------------------------------------------------------------------
Received invalid column length from bcp client.
(Source: COM10 (Data source); Error number: 4815)
---------------------------------------------------------------------------------------------------------------
Function sequence error
(Source: ODBC Driver Manager (ODBC); Error number: 0)
---------------------------------------------------------------------------------------------------------------


I would be very thankful for an early reply as the replication is to be done very urgently.

Thanks and regards
Sandeep Shetty"

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-11-26 : 11:18:29
Snap shot needs to be created on the PUBLISHER.
Also all the publishing and subscribing servers need access to the snapshot folder.

------------------------
I think, therefore I am
Go to Top of Page
   

- Advertisement -