Background replication

We are developing a embedded system based on Windows CE 5 and SQL Server CE 3 in C++ where we need to do merge replication in background while the front end application still need to perform operations on the database. A solution would be to run the merge replication on a separate thread while the application thread still can access the database to do inserts and updates. I have been researching if it is possible to access the database with queries during a merge replication, but I can not find an answere. Does anyone have experience of this and generally know if it is possible to implement with SQL Server CE 3 in the native API?

Best regards

Johan Johansson

This article may help you understand the implications of a user trying to access SQL Mobile while merge replication is happening.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5mobilesynch.asp

Darren

|||

Thanks Darren, this is exactly what I was looking for.

Best regards

Johan

Auto-print a report in 'local' mode?

Hello,
Is there a way to auto-print a report without any user interaction?
We're using 'local' mode with the reports embedded in the application;
there is there is no reporting server.
At the moment, a button on a form opens another form which contains a
ReportViewer control. This report viewer control is populated with a
report at runtime, and the report is displayed to the user. Very nice.
Now, the requirement is for that button to automatically 'print' the
report. (Thus saving the user the manual process). Is this possible?
I know there has to be some way to tell it which printer to print to.
Done some searching and there doesn't seem to be an easy answer. There
are ways, but they involve a reporting server to be present.
Any hints or ideas would be great.
Thanks,
Jackyou might try this: http://forums.asp.net/p/516455/533549.aspx
HTH!
On Apr 16, 3:37 am, Jack <bradnerd...@.hotmail.com> wrote:
> Hello,
> Is there a way to auto-print a report without any user interaction?
> We're using 'local' mode with the reports embedded in the application;
> there is there is no reporting server.
> At the moment, a button on a form opens another form which contains a
> ReportViewer control. This report viewer control is populated with a
> report at runtime, and the report is displayed to the user. Very nice.
> Now, the requirement is for that button to automatically 'print' the
> report. (Thus saving the user the manual process). Is this possible?
> I know there has to be some way to tell it which printer to print to.
> Done some searching and there doesn't seem to be an easy answer. There
> are ways, but they involve a reporting server to be present.
> Any hints or ideas would be great.
> Thanks,
> Jack|||On Apr 16, 6:11=A0pm, "Jerry H." <boilersr...@.gmail.com> wrote:
> you might try this: =A0http://forums.asp.net/p/516455/533549.aspx
> HTH!
> On Apr 16, 3:37 am, Jack <bradnerd...@.hotmail.com> wrote:
>
> > Hello,
> > Is there a way to auto-print a report without any user interaction?
> > We're using 'local' mode with the reports embedded in the application;
> > there is there is no reporting server.
> > At the moment, a button on a form opens another form which contains a
> > ReportViewer control. This report viewer control is populated with a
> > report at runtime, and the report is displayed to the user. Very nice.
> > Now, the requirement is for that button to automatically 'print' the
> > report. (Thus saving the user the manual process). Is this possible?
> > I know there has to be some way to tell it which printer to print to.
> > Done some searching and there doesn't seem to be an easy answer. There
> > are ways, but they involve a reporting server to be present.
> > Any hints or ideas would be great.
> > Thanks,
> > Jack- Hide quoted text -
> - Show quoted text -
Thanks for the info, but this seems to be for 2000 (I'm using RS
2005). Not only that, this is using the 'server' mode, whereas we're
using 'local' mode.
Any other ideas?
Cheers heaps...