Problems with Merge Replication

[Guest]

Hi
currently using merge replication within in a background thread which is running every 2 min. When i make a select on the same DB during merge is running i get an access file violation. It looks like the merge locks the DB. If the select is faster the merge throws a exception! i afraid that there is only one open connection to the DB possible which will make it impossible to do a background merge while somebody is working and entering some data

Has anybody a solution for this or is there something basic i do wrong
Or is there at least anybody who can tell me if a select stament is possible during merge.synchronize() is running

please help

 

[éric]

sqlce 2.0 only allows for 1 connection at a time
There is no work around as far as I know.

sqlce 3.0 will allow you to have multiple connections and replicate while
selecting inserting updating deleting.

http://microsoft.sitestream.com/PDC2003/
click Mobile and the have a look at MBL 314

Regards,
éric

Hi,
currently using merge replication within in a background thread which is

running every 2 min. When i make a select on the same DB during merge is
running i get an access file violation. It looks like the merge locks the
DB. If the select is faster the merge throws a exception! i afraid that
there is only one open connection to the DB possible which will make it
impossible to do a background merge while somebody is working and entering
some data.

Has anybody a solution for this or is there something basic i do wrong !
Or is there at least anybody who can tell me if a select stament is

possible during merge.synchronize() is running ?