Very Computer

1. Error when subscribing to Merge replication

Hi,

We have setup a publisher and a distributor in SQL 2000 running SP3.
Alongwith this we have setup a merge replication agent and its running
successfully inside the same network. I allow anonymous subscriptions and
the merge publication works successfully for anonymous pull subscriptions
also.

Now i am trying to setup the same scenario to setup replication over the
Internet using FTP. I have created a FTP site and given certain accounts
credentials to login to the same. I have checked the same over a browser and
the ftp protocol is working perfectly.

In my publisher i have changed the path of the snapshot folder to the ftp
folder (which is in the same network). I refer to the same in snapshot
location screen as \\Systems\SQL FTP\. It is a shared for which sufficient
rights are there.

The snapshot agent generates the snapshot in this folder without any
problem.

Now when i create a pull subscription, and say scynchronize using FTP, it
fails and after checking the job history, these are the messages that were
there -

Category:NULL
Source:  Merge Replication Provider
Number:  -2147201001
Message: The schema script '' could not be propagated to the subscriber.

Category:AGENT
Source:  PARAM
Number:  0
Message: The process could not connect to FTP site '203.129.229.172' using
port 21.

Category:OS
Source:
Number:  12003
Message: 550 ftp://203.129.229.172: The filename, directory name, or volume
label syntax is incorrect.

The schema script '' could not be propagated to the subscriber.  The step
failed.

And by the way, if i try to push the subscription via FTP it works without
any problem.

Can someone please advice what is to be done ? Thanks in advance!

Thanks,
Karthik.

2. Creating lobindexes

3. How to subscribe a Merge Replication using MSDE

4. SQL: conditionally return string constants for certain fields

5. Unable to subscribe merge replication

6. SQL Server Upload

7. Message - No data needed to be merged - using merge replication

8. Help with NOT EQUAL in SQL statement

9. Merge Replication : Merge Agent fails with Garbled sp name errors

10. merge replication using Active X merge control

11. merge replication doesn't merge records

12. Merge Replication with ftp fails after adding A New Merge Article

13. Merge Replication, on-demand PULL replication