Requirement:
-------------
we are developing Accounting packages and we used to release periodical updates(patches) for these packages which we keep in the web site, customer has to download there patches and has to install them.
while installing these patches customer is facing problems. so to rectify this problem we have planned for auto updation just like windows updates.
Process:
--------
A service will running on the customer system which periodically checks the internet connection , when the connection establishes it runs an executable file which will opens local database consists of latest files (present in the system) information and downloads the latest files (files ready for download from website) information database from website.
it compares both databases if any new files information exists it updates into the localdatabase and starts downloading the files from web site, after downloading all the files it performs the necessary operations to be performed to run the package.
Development:
------------
i wrote service stuff in VC++
and the exectable stuff in VB and the database is .mdb MSACCess file
Problem*-******
---------
I Installed Service it is running well , and opening the exectutable file when the internet connection establishes to the system (so it means service it is working well till here)
i can see both service file and executable file in the task manager
the executable file is opening the local database and next it start trying to collect the database from the web site, here it stops working , it is not returning any message and not logging any thing.
when i run the executable file directly by double clicking on it , it is performing all the functions(opening the local databse , collecting the databse from website, updating the database and downloading all the files)
i even tried by running the executable file from command prompt here also it is working well.
i am facing problem only when i try it from Service.
command i used to open the executable file is :
ShellExecute(NULL, "open","C:\VUpdate.exe", NULL,NULL, 1);