RTC (win) Service auto-shutdown

[zsleo]

I have an app that has been running as a non-service EXE for a few months.

I converted it to run as a Win Service. Still runs perfectly as a non-service EXE but when I start the win-service it shuts down immediately.

I have traced my problem as follows:
 I have a TADOConnection in the application and when the Open is called, the database connection starts, logs on successfully then the service stops.

I don't know if it is the RTC or ADO stopping the service.

There are no errors or exceptions being generated - there is a clean log off, disconnect from the MS SQL db (ADO) and stopping of the service.

Any ideas?

TIA

Zane

[zsleo]

... just as I sent posted the request I thought I should look at the Event Viewer....

"Service failed on start: CoInitialize has not been called"

Sorry....

Zane

[D.Tkalcec (RTC)]

Using the rtcActiveX unit somewhere in your Project should fix that problem. The only purpose of that unit is to call "CoInizialize(nil)" for every RTC Thread when the Thread starts and "CoUninitialize" before the Thread stops. These calls are required when using ActiveX components.

Best Regards,
Danijel Tkalcec

[zsleo]

Thanks, Danijel.

I should have known there would be an rtcActiveX   

I fixed my issue by calling CoInitialize directly and including ActiveX.

Are you saying that if I include the rtcActiveX then I done need to call CoInitialize?

Regards,

Zane

[D.Tkalcec (RTC)]

Correct. That is the purpose of the rtcActiveX unit. It adds a new handler to RTC Thread creation and destruction code, which makes sure that CoInitialize is called automatically for each RTC Thread after it is created and CoUninitialize before it is destroyed. This way, you don't need to call it every time before you need to use ActiveX controls from RTC events executed in background threads. And because the call is made only once for every thread, it will also cost less CPU time than it would if you are calling it manually.

Best Regards,
Danijel Tkalcec

[zsleo]

Thanks.

The change will be made today.

Regards

Zane