Post reply

Problem with Queued updatable subscriptions

  • March 7, 2008 at 10:56 am

    #187564

    Hi All,

    I have a problem replicating data from Subscriber to Publisher.

    I configured Queued updatable subscriptions in transactional replication. Publisher is on SQL Server Standard edition and Subscriber is on SQL Server Express edition, both on Windows XP.

    When I insert/update data in publisher, the data is replicated to subscriber. If I insert/update data on subscriber the data is not replicated. When I see the replication monitor for errors, it shows an error "Cannot load a DLL xprepl.dll or one of its resources".

    Could any one give me a solution or please tell me if I missing something?

    Thanks you all,

    Ravi.

    Regards,
    Ravi.

  • March 8, 2008 at 12:24 pm

    #787057

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98640

    cross post.

    Are both versions of SQL the same and updated through the same service packs?

  • March 9, 2008 at 1:26 am

    #787118

    Yes, both the versions of SQL are same SQL Server 2005, but editions are different Publisher is configured on SQL Server 2005 Standard Edition and Subscriber is configured on SQL Server 2005 Express Edition. I can see the xprepl.dll in Binn folder, but unable to register it. Error is thrown while registering the DLL "LoadLibrary('D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xprepl.dll') failed - The specified module could not be found."

    I uninstalled the SQL Express edition and installed it again and configured the replication. Same error is replicated again.

    Don't know how to get out of this error.

    Thanks,

    Ravi.

    Regards,
    Ravi.

  • March 9, 2008 at 1:30 am

    #787119

    And updated with latest service pack (SP2)

    Regards,
    Ravi.

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

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