Why can't they check it in a Connect function before they send a query command? - either they connect or they don't, return false if you can't connect and don't continue, or even better try again after x mins, or try alternate site after x attempts, etc...
Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Reiser, John J Sent: Thursday, June 30, 2011 12:48 PM To: [email protected] Subject: Select statement to check for connectivity from external source Hello Listers, MS 2003 Enterprise SP1 on VMware ARS 7.6.03 MS SQL Server 2005 on remote SAN I have a department that is running select statements against the ARSystem to run iDashboards. They need a validation statement to confirm that the database is available. Currently they run SELECT COUNT(*) FROM ARS_FORM WHERE 1=1 because I have Unqualified searches disabled. I tried to point them to the group form with select group_name from Group where Group_ID = 0 so they can verify that "Public" is returned. The problem is that the Group form is only available to ARS Administrators. I know I can make a "Hello world!' form and store one record and give it public permissions but I know the group form will always be there. Group is a core form, Public is a core group. They also do a lot of Select statements with no WHERE clause against the form to pull ticket information that they process and display on a web site external to the ARSystem network through a web service. I am trying to keep the load on the ARSystem manageable. Does anyone have any suggestions? Should I add Public access to the group form but keep it hidden? Will an upgrade reset the permissions? Can I control the search qualification by altering the web service? Should I aggregate their data for them and serve it up from a separate form? This "Portal" will be getting hit by multiple people all day long. I don't want the excess traffic slowing down the whole system. Thanks you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
