1

I have provisioned a SQL Server CE database with Microsoft Sync Framework. When I insert a new record remotely, the __sysChangeTxBsn column remains empty. When I copy the database to my local computer and insert a record locally, the __sysChangeTxBsn column receives a value, as expected. Why does change tracking work locally but not remotely?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Shaun Luttin
  • 133,272
  • 81
  • 405
  • 467

1 Answers1

1

The problem was a mismatch in SQL Server Compact version/service pack on the local and remote machines.

For future reference, here are the relevant links.

SQL Server Compact 3.5 SP1

SQL Server Compact 3.5 SP2

Steps

  1. Choose to use either SP1 or SP2 but DO NOT mix the two!
  2. Download and run the "for Windows Desktop" installer.
  3. Download and run the "For Windows Mobile" installer.

If you're on an x64 computer and you chose SP2, after install your Add/Remove programs should look like this:

Add/Remove Programs

And you should have a directory at C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5 that contains the relevant DLLs and CABs.

Good luck!

Shaun Luttin
  • 133,272
  • 81
  • 405
  • 467