Close the application which opened the connections to the database?
<i>Can someone tell me the cleanest method to end ODBC connections?</i>
The “cleanest” will always be the suggestion above. There’s no way around that. Everything else will have some ‘dirty’ component or potential.
<i>I was going to try just ending the Qusrwrk sub-system but I’m not sure if the jobs will just restart in Qserver.</i>
That will depend on how your system is configured.
<i>I’m also looking at an Endhostsvr (*database) endactcnn(*database) to see if that will do it.</i>
If you need to have control from the server side, this will be your best chance at being the closest to “cleanest”. Obviously, cutting a connection will have results directly related to whatever a remote connection is being used for at the time the cut happens. I don’t know of any way to determine that without understanding the relevant remote apps.