Devart Forums

Hi

I am having an issue converting from 3.55 to 4.10 .

We have a threaded NT service that works OK (we have been using for some time with many thousands of users).

When we use 4.10 start the service so it connects to a database then turn the machine off. I am using Win 2003 server. It takes long time to shut down the MACHINE when using driver 4.10 ie a few minutes.

When using 3.55 it takes 7 seconds to shut down .
This is VERY repeatable.

I must say that if I start / stop the service it takes no time at all, it is just when the machine is turned off. I have tried logging etc.. and cannot see where it is taking the time

Any thoughts as we need to be able to support Windows 2003 Server. If I use 3.55 I can get round this issue BUT cannot support Vista.

All the best (and worrried)

Mike

I

More information.

I have test with the last version of 3.80.0.38 07.06.07 and it works to the extent that the server machine shuts down as expected.

Mike

Hi

Tried 4.00.0.6 20.04.07 and it did take it's time like the other version of 4
for the machine to shut down.

Mike

Please make a small test service application that reproduces this problem and send this application to us at evgeniyd*crlab*com for test. Also include the script to create server objects used by the application.

Please I do not have the resources at the moment. Please can you do this as it would be a useful testing tool for yourselves!

Write NT Service
create thread
connect to database
Create Query + Store proce objects
Do nothing more....

Close Machine

The machine waits a few minutes to close if using any version 4 of the application.

Perhaps you could use SQL Profiler to run a trace to log the events to a database table or log file when you close the machine, and compare the events that are generated for both versions 3 and 4 of SDAC.

Hi

I will give it a try, later on but I am doing NOTHING with the database except copnnected to it. Unless your components do something else?.

Please can YOU not try yourselves?

Mike

I created a test service application following the steps you have provided, but could not reproduced this problem. If the service application is run, time of my computer shutdown is the same.

Hi

Could you please send the source / exe to me I will try it on one of our servers.

Mike

I have sent the exe file and sources of my service to you by e-mail.

Hi

Thanks very much for that. Could you please email them to [email protected] as well as I cannot access the other account at present.

Mike

I have forwarded them to the specified address.