[?]: Read database from Wonderware historian server

[roprez]

Hi, I`ve just installed a Wonderware Historian Server 9.0 (also called InSQL) with Microsoft SQL SERVER 2005, on a Windows SERVER 2003 O.S.
I don´t have licence for ActiveFactory or Information Server, but I would like that 2 computers (with Intouch 10) could read the database from the server, and do the trends with that information, instead of saving it own database.
The thing is that the server is being used as a HARDDISK now, because its just saving data, but I can´t do anything with it, because I would have to program in SQL.

Hope someone can help me, because I know it can be done.

[bunglehead]

The thing is that the server is being used as a HARDDISK now, because its just saving data, but I can´t do anything with it, because I would have to program in SQL.

What do you mean here? If you want to display trends from InSQL without AF trend activex you just need to configure an history provider in InTouch application and then use general InTouch Historical trend. This is fully documented, so feel free to read documentation on InTouch Histt providers.

[roprez]

Thanks bunglehead, I`ve already configured a general historical trend in Intouch,
but I still have problems.

I use the "Distributed Name Manager" and configure an InSQL Provider,
I even get logged to the server,
and I can see the tags configured in it,
but when I use the tag in a trend, no data is displayed.
The way to assign the pen to the historical trend is "PROVIDERNAME.tagname".
I think the SQL server is not working ok,
i know it is receiving data but maybe it`s not saving it.

Hope someone have experience on it.

[bunglehead]

I think the SQL server is not working ok,
i know it is receiving data but maybe it`s not saving it.

Hope someone have experience on it.

First of all check InSQL node, its configuration. Get the InSQL start properly, look at console messages, etc.
After that try to query data locally, on InSQL node. Then the same remotely.