Pocket pc 2002 sqlce data synchronization with sql server 2000 (SP4)

i am using C#..net
I am synchronizing the sql server data with sqlce.but i get an error when i call synchronize function. i am using sqlcereplication class.
the error is
"a call to sql server reconciler failed"
native error 29006
and sometimes
native error
29045.

Details please:

1) SQL Server version - 2000 or 2005

2) SQL Mobile version - 2.0 or 3.0

3) IIS Version

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||1)sql server 2000 SP2.
2) pocket pc 2002
3) IIS 5.1
4)VStudio 2003
5) C#.net.
waiting for ur reply.
thnkx
|||

Ok here is what I understand:

You are using SQL CE 2.0 version Database on device Pocket PC 2002 and trying to sync with SQL Server 2000 SP2. However the title of the thread goes with SP4. It is confusing to me, which one is correct?

Irrespective of all of this, I would recommend you to go thru the page http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx very carefully and I am sure you would be knowing how sqlcereplication works at the end of the read.

1) I think SQL Server 2000 SP < SP3a are not supported by Microsoft anymore. So, please upgrade to SP4.

1) Install SQL Server 2000 Client Components in IIS

2) Install SQL CE 2.0 Replication Tools @. http://www.microsoft.com/downloads/details.aspx?familyid=79071E22-52F5-4189-998E-FD03648FD3F4&displaylang=en

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation