Member Login
member
passwd
remember me on this computer.

- join now -

Search

Past & Future Posts
Neat Stuff

Visit our shop for nerds in control lifestyle products.

Cool stuff
Select a topic of interest:
...and press:
Fortune
Give a man a fish, and you feed him for a day. Teach a man to fish,
and he'll invite himself over for dinner.
-- Calvin Keegan
RSS Feed
RSS feed Use this link to get an RSS feed of the Control.com article flow, for private, non-commercial use only:
www.control.com/rss
Select a Page Style
Select one of the following styles:
- BluFu
- Classic
(cookies required)
from the Automation department...
Alarm Database problems
HMI topic
advertisement
Posted by Rahul on 27 February, 2008 - 11:26 pm
Alarm db viewer doesn't display historical data when I try to take it from in-sql. We have Microsoft SQL and INSQL both installed on one machine. While configuring (window maker) alarm I put the proper server name, login id (sa) and password. When I do test connection it shows connected but when I go to run time mode and try to take historical time it takes a long time and gives me message "Timeout expired". When I close message it shows disconnected at bottom right and bottom left it shows the name of server. What is the problem? Can anybody please tell me?

Posted by KS on 8 April, 2008 - 1:06 am
You can set the no. of alarms to be display as 100 at one time or assign the StartTime and EndTime properties within a certain period. This will filter the amount of alarms querying from the database and reduce the query time.

From Control Engineering magazine...
Related articles from Control Engineering magazine
Above articles copyright 2008 Reed Business Information. Subject to its Terms of Use.

Your use of this site is subject to the terms and conditions set forth under Legal Notices and the Privacy Policy. Please read those terms and conditions carefully. Subject to the rights expressly reserved to others under Legal Notices, the content of this site and the compilation thereof is © 1999-2008 Control Technology Corporation. All rights reserved.

Users of this site are benefiting from open source technologies, including PHP, PostgreSQL and Apache. Be happy.

Advertisement
Our Advertisers
Help keep our servers running...
Patronize our advertisers!