Post reply

ODBC error:could not update the publisher becuase subscription has been dropped. use sp_subscription_cleanup to cleanup triggers.

  • May 4, 2005 at 11:59 pm

    #164196

    hi

    i have 2 servers pub1 and sub1 (remote subscriber). i setup transactional queued update replication is implemented between them. when i make change in publisher it's easily replicating to subscriber without error. but when i make some insertion in subscriber, queue reader is failing and giving the following error: ODBC error:could not update the publisher becuase subscription has been dropped. use sp_subscription_cleanup to cleanup triggers.

    help needed urgent.

  • May 9, 2005 at 4:44 am

    #557556

    hi

    i am able to solve the above issue after 3 days.

    the main issue is i registered sql server with IP address.

    solution is: so i made an entry in the C:\WINNT\system32\drivers\etc\hosts.txt file of publisher server. the entry i made is subscriber server's host name, example '192.168.10.33 FS6'.

    and then registred sql server with the name FS6 instead of instead of using IP address. And then i set up transactional queued update replication, it's working fine.

    thax and regards

    kiran

    thanneerukiran@yahoo.com

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

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