Post reply

Replication to Heterogeneous Subscribers

  • November 14, 2002 at 12:21 pm

    #79261

    Hi,

    I want to create a PUSH subscription( using Transactional Replication) from an SQL-2000 DB to SQL 6.5 and Access Databases via ODBC.

    After creating the subscription, (and restarting the Snapshot agent) the Syncronization tasks fails when creating the tables on the SUBSCRIBER

    It seams that Access and SQL-6.5 don't like this part of the CRATE TABLE statement:

    [msrepl_tran_version] [uniqueidentifier] NOT NULL CONSTRAINT [DF__Internet___msrep__70C8B53F] DEFAULT (newid())

    What do I haveto do in order to work around this?

    TIA

    Sverrir

  • November 14, 2002 at 3:47 pm

    #441409

    Did you make sure to choose the option for not all subscribers would be SQL? I haven't tried this yet but will be able to test next week when I have my machine installed here and configured for some other testing I want to do.

Viewing 2 posts - 1 through 2 (of 2 total)

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