Problems with Merge Replication

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

Necrite said:
Hi,
currently using merge replication within in a background thread which is
Click to expand...
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
Click to expand...
possible during merge.synchronize() is running ?
 
Back
Top