Post reply

MSDE 2000 SP4 - Native Error 25007 - The operation cannot be performed in a transaction

  • December 27, 2007 at 2:45 pm

    #95696

    Hello,

    I am using SQL Server 2000 Desktop Engine (MSDE) SP4 and SQL Server CE 2.0 SP4. I am attempting to perform merge replication between a handheld device with Pocket PC on it and the MSDE database which resides on a laptop running Windows XP SP2. I have done this many times before without any problems. I just set up a new standalone laptop to replicate with one handheld and now I am having issues. Replication is failing with native error 25007 "The operation cannot be performed in a transaction". This error is proceeded by native error 28555 'The SQL Server CE database cannot be replicated. The subscription must be reinitialized". Replication was just set up though and the snapshot agent was just run. The subscription on the handheld is new and is being created. My handheld database size only reaches 44kb before replication fails with these errors. Any help would be very appreciated.

    Thanks!

  • January 1, 2008 at 2:58 pm

    #763882

    Figured this out: the proxy server was set to "127.0.0.1:2080" and it needed to be "ppp_peer:80". Use the former if you're using wireless and replicating through an appliance and use the latter if you're replicating through a cradle.

    Thanks

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

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