Re: [foxboro] AIM*Historian connection on Windows
- From: "Perez, Claudio" <CPerez@xxxxxxxxxxxxxxxx>
- To: "'foxboro@xxxxxxxxxxxxx'" <foxboro@xxxxxxxxxxxxx>
- Date: Thu, 4 Nov 2004 14:50:17 -0300
Sorry to said this, but don=B4t waste your time.
Trying to get event messages does=B4t work. We spend a lot of time =
trying to
recover alarms through ODBC, until Invensys Argentina people told us =
that it
isn' t supported.
Good Luck.
Claudio A. Perez
Control Systems Eng.
PROFERTIL S.A.
(54) 291 459-8139
cperez@xxxxxxxxxxxxxxxx
www.profertil.com.ar
-----Mensaje original-----
De: Ales Vaupotic [mailto:ales.vaupotic@xxxxxxxx]
Enviado el: Mi=E9rcoles, 3 de Noviembre de 2004 20:24
Para: foxboro@xxxxxxxxxxxxx
Asunto: [foxboro] AIM*Historian connection on Windows
Hi,
here is my real problem:
I have written a program which connects to AIM*Historian and collects
the RTP samples and reduction values. It works perfectly. I got stuck
when trying to get the alarm messages from AIM*Historian. I work in the
following 70-series environment:
Windows XP with SP1
I/A release 7.1
AIM*AT 3.2.1
AIM*API version 5.4.0
The problem is the fh_FdbMsgQuery call which doesn't seem to return the
data as specified in the manual. Has anyone got any experience with =
this
call? Also, there is fh_FdbMsgQueryFilterNew function which is not
described in the manual but works in apitst. I looked over The =
Cassandra
project and couldn't find a similar program. Have I missed someting? My
manual is B0193YN, rev. C, from March 3, 2003.
The other problem is ODBC and OLE*DB on Windows. I keep getting strange
resultsets from them. Sometimes RecordCount is accurate but after first
record it is already at EOF. Or, it returns different fields on two
subsequent calls with the same SQL command. The first field is =
sometimes
a table name or tag name and after another call there is no such field.
Wierd! Is there anyone actually using OLE*DB connetion to AIM*Historian
from PHP or ASP?
I would be happy with any other solution to get to the data I need into
my PHP or ASP or C or ....
Thanks for you help, everyone!
Ales
=20
=20
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
=20
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
to unsubscribe: =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
=20
Esta informaci=F3n es privada y confidencial y est=E1 dirigida =
=FAnicamente a su
destinatario. Si usted no es el destinatario original de este mensaje =
y por
este medio ha tenido acceso a dicha informaci=F3n, por favor elimine el
mensaje. La distribuci=F3n o copia de este mensaje est=E1 estrictamente
prohibida. Esta comunicaci=F3n es s=F3lo para prop=F3sitos de =
informaci=F3n y no
debe ser considerada como propuesta, aceptaci=F3n ni como una =
declaraci=F3n de
voluntad oficial emanada de Profertil S.A. La transmisi=F3n de e-mails =
no
garantiza que el correo electr=F3nico sea seguro o libre de error. Por
consiguiente, no manifestamos que esta informaci=F3n sea completa o =
precisa.
Toda informaci=F3n estar=E1 sujeta a alteraciones sin previo aviso.=20
This information is private and confidential and intended for the =
recipient
only. If you are not the intended recipient of this message you are =
hereby
notified that any review, dissemination, distribution or copying of =
this
message is strictly prohibited. This communication is for information
purposes only and shall not be regarded neither as a proposal, =
acceptance
nor as a statement of will or official statement from Profertil S.A. =
and/or
subsidiaries and/or affiliates. Email transmission cannot be guaranteed =
to
be secure or error-free. Therefore, we do not represent that this
information is complete or accurate and it should not be relied upon as
such. All information is subject to change without notice.
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
Other related posts:
