windows service error

[NarendraSinghJTV]

hey all with the help of eduard's response for my previuos message "windows service installation" i have installed my application and service both, but when i start my service it is giving following message and stops "the service on local computer started and stopped. Some services stop automatically if they have no work to do for example the performance logs and alert services" can u help me with this thanks for responses regards narendra singh

[ScottM1]

The message is self explanatory, your service is starting, finishing processing whatever you told it to, and then stopping. What is the service supposed to be doing that would keep it running?

[NarendraSinghJTV]

yes scott i m agree with u but it is not performing the actions defined within onstart(), service have to send a message and then it should be stop

[Abhijit Jana]

Debug your services. It throwing some exception at runtime ! :) That's why you are getting this message.

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

[ScottM1]

Where is it sending a message? Is it connecting to a server socket and sending a message or what?

[NarendraSinghJTV]

actually it is sending a e-mail message to wish happy birthday by taking the dob from the database

[NarendraSinghJTV]

yes abhijit u r absolutely right it is throwing an exception actually i m using single database in both application as well as service. but sql server is not allowing to access the database which is already in use, it is generating a error which says .mdf file is already in use thanks for ur response

[ScottM1]

Then it is probably sending the e-mail and failing but it is not notifying you that it failed. Try running the code in a normal application and see if the e-mail is sent. What account are you running the service under?

[NarendraSinghJTV]

actually i m using single database in both application as well as service. but sql server is not allowing to access the database which is already in use, it is generating a error which says .mdf file is already in use, i m running service under local system thanks for ur response

[ScottM1]

If it is giving the error that the mdf file is already in use then it is probably a MS Access database and you probably have the database open in access or you did not close the connection properly and the database is still locked. Is there an ldb file in the same directory?

[NarendraSinghJTV]

ok let me explain i m creating a application in which i want a functionality of wishing happy birthday automatically to the customers by sending email by taking there dob from the customer table which is in sql server 2005 database, so i added a windows service project in same solution and done all the coading in onstart(), i also created a setup which install both application and service on the local system, after installing when i try to start the service then problem occurs, i provided connection string for the database also, can we use single database in different projects in same solution, i think now the problem is clear to you. waiting for ur response thanks

[ScottM1]

If it is an MS Access database you could have problems accessing it from multiple projects simultaneously depending on how you connect to the database. I think that instead of using a Windows service you should just build a simple console application that runs once a day from task scheduler.

[NarendraSinghJTV]

hey scott thanks for ur all replys, now i have added this functionality in application itself, with the help of functions, which checks the date from database and send mail automatically to the contact. thanks for ur responses regards narendra singh

[Ashfield]

NarendraSinghJTV wrote:

done all the coading in onstart(),

Well don't. OnStart is just for that. Move your code and try debugging by connecting to your service from the ide - and you cannot debug the OnStart code. Also try logging errors soemwhere (say a file) so you can see whats going wrong.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[NarendraSinghJTV]

thanks bob for ur valuable response thanks for all the responses regards narendra singh