creating window service to synchronize local database toserver database

  • Thread starter Thread starter sujatha k
  • Start date Start date
S

sujatha k

I want to create one window service to synchronice my local database with server database.i've done the synchronization process in .net application it is working fine. i copied tat code and put it in windows service OnStart() method. but it is not working. i'm very new to window services. please help me out in this.
 
I want to create one window service to synchronice my local database with
server database.i've done the synchronization process in .net application
it is working fine. i copied tat code and put it in windows service
OnStart() method. but it is not working. i'm very new to window services.
please help me out in this.
Click to expand...


The OnStart method needs to finish quickly, otherwise it will give a timeout
error when starting the service.

If your service is intended to synchronice the databases periodically, you
will want to use OnStart method to start a Timer, and exit. The Timer event
will then perform the synchronization with the periodicity that you need.
 
Normally the issue here is that a service runs in a different security
context (commonly "local service" or "network service") which means
that it won't have the same rights (on the network) that you do. Try
running the service is a dedicated user identity that has access to
the database.

Or tell us more about "not working" - i.e. the exact error message /
behaviour.

Marc
 
I am facing the same database synchronisation issue.Can u simply guide me through the entire
process you followed to synchronize the local database of the application with the server database.
Need to know the step by step approach you followed.I tried many ways but of no use.Do i have to use windows service.
I am totally new to windows services.Plz look into my issue.
 
I am facing the same database synchronisation issue.Can u simply guide me through the entire
process you followed to synchronize the local database of the application with the server database.
Need to know the step by step approach you followed.I tried many ways but of no use.Do i have to use windows service.
I am totally new to windows services.Plz look into my issue.
 
Hello,

This is very interesting concept. I also want to do this in my windows application. so would you provide me your code/logic whatever you have done..



Thank You,
karmraj.
 
Back
Top