2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

29006 SQL SERVER ERROR

HI, I'm getting this error on a merge subscription between SQL SERVER
2000 and SQL SERVER CE 2.0. Ocurrs 4 error:
1. A call to SQL Server reconciler failed. 29006
2. The process could not log conflict information.
3. {call [ap_cft_956C31C4D7234B324E83FF479D5444B7](?,?,?,?,?,?,?)}
4. Datetime field overflow
Any Idea?
Thanks,
Yllen
Is this a custom resolver? If not can you enable logging and post the
complete log here?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Yllen" <yguevara@.gmail.com> wrote in message
news:1126629526.156630.85200@.g47g2000cwa.googlegro ups.com...
> HI, I'm getting this error on a merge subscription between SQL SERVER
> 2000 and SQL SERVER CE 2.0. Ocurrs 4 error:
> 1. A call to SQL Server reconciler failed. 29006
> 2. The process could not log conflict information.
> 3. {call [ap_cft_956C31C4D7234B324E83FF479D5444B7](?,?,?,?,?,?,?)}
> 4. Datetime field overflow
> Any Idea?
> Thanks,
>
> Yllen
>

2005: sp_helpdevice returns 0 results

On a new install of SQL Server2000, sp_helpdevice returns at least one result
(for master) and you can call
sp_helpdevice 'master'
to always get that row.
On SQL Server2005, sp_helpdevice on a new install returns no results, and
sp_helpdevice 'master' generates an error.
Anyone know how to find out the file path where the master database is stored?sp_helpdevice was used to return the name/location of backup devices, so it
seems an odd choice to use just to return the location of master.
Anyway, in SQL Server 2005, you want to use system catalog views. For
example, the following statement returns the physical location of the master
database files.
SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('master')
For additional information about catalog views, see the topic "Catalog Views
(Transact-SQL)" in Books Online.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"michael pryor" <michael pryor@.discussions.microsoft.com> wrote in message
news:78862BE2-74CB-446E-B119-3B2518596A60@.microsoft.com...
> On a new install of SQL Server2000, sp_helpdevice returns at least one
> result
> (for master) and you can call
> sp_helpdevice 'master'
> to always get that row.
> On SQL Server2005, sp_helpdevice on a new install returns no results, and
> sp_helpdevice 'master' generates an error.
> Anyone know how to find out the file path where the master database is
> stored?|||Is there a problem with using sp_helpfile 'master' and looking at the
filename?