Problems replicating - sql2000 and MSDE

  • I am trying to setup a snapshot replication between sql2000(publisher) and MSDE subscribers across the internet. I am trying to accomplish this through a VB.Net program that uses the MS SQL Replication COM objects. Everything appears to be working....the snapshot is generated on the publisher and when the distributor attempts to get it to the subscriber, I get the following error:

    "The subscription to publication 'TestSnapshotPublication' has expired and does not exist."

    How can a subscription expire...if I just set it up? In fact, I checked the box on the publication to not Expire....so, am I missing something else?

    Thanks....

    Douglas

  • This was removed by the editor as SPAM

  • Thanks for the reply. I took a quick look at the article and I don't believe that the servers are set up as case-sensitive. I can verify this later, but I feel confident that they are quite insensitive.

    Thanks.

  • How are the subscribers setup? the transfer sends all the ddl and data to a temp directory where its read in. Do they have all the neccessary requirements?

    and they have all been set up as subscribers with the appropriate rights, etc...

    Edited by - Scorpion_66 on 11/14/2002 5:36:14 PM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply