creating window service to synchronize local database toserver database

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • sujatha k

    #1

    creating window service to synchronize local database toserver database

    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.
  • Alberto Poblacion

    #2
    Re: creating window service to synchronize local database to server database

    "sujatha k" wrote in message news:2008919312 45sujatha@evern et.co.in...
    >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.

    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.

    Comment

    • Marc Gravell

      #3
      Re: creating window service to synchronize local database to serverdatabase

      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

      Comment

      • rajni sharma

        #4
        Query post

        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.

        Comment

        • rajni sharma

          #5
          database synchronisation 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.

          Comment

          Working...