Re: [foxboro] AIM*Historian connection on Windows
- From: "Brennen, Robert SCAN--" <Robert.Brennen@xxxxxxxxx>
- To: <foxboro@xxxxxxxxxxxxx>
- Date: Thu, 4 Nov 2004 11:07:28 -0700
Greetings,
We have this working after we purchased a product called "Alarm =
Extractor". This is an Excel Addin and requires that you purchase a =
license which allows an additional ODBC connection to the AIM* =
Historian. Evan if you wrote the addin yourself, I suspect it would not =
work without the ODBC connection license. Cost for the license is not =
expensive.
This product works very well for us and allows all AIM* data to be =
pulled and populate an Excel Spreadsheet.
....regards
Rob Brennen
Shell Canada
> -----Original Message-----
> From: foxboro-bounce@xxxxxxxxxxxxx=20
> [mailto:foxboro-bounce@xxxxxxxxxxxxx]On Behalf Of Perez, Claudio
> Sent: November 4, 2004 10:50 AM
> To: 'foxboro@xxxxxxxxxxxxx'
> Subject: Re: [foxboro] AIM*Historian connection on Windows
>=20
>=20
> Sorry to said this, but don=3DB4t waste your time.
> Trying to get event messages does=3DB4t work. We spend a lot of time =
=3D
> trying to
> recover alarms through ODBC, until Invensys Argentina people told us =
=3D
> that it
> isn' t supported.
>=20
> Good Luck.
>=20
> Claudio A. Perez
> Control Systems Eng.
> PROFERTIL S.A.
> (54) 291 459-8139
> cperez@xxxxxxxxxxxxxxxx
> www.profertil.com.ar
>=20
>=20
>=20
>=20
> -----Mensaje original-----
> De: Ales Vaupotic [mailto:ales.vaupotic@xxxxxxxx]
> Enviado el: Mi=3DE9rcoles, 3 de Noviembre de 2004 20:24
> Para: foxboro@xxxxxxxxxxxxx
> Asunto: [foxboro] AIM*Historian connection on Windows
>=20
>=20
> Hi,
>=20
> here is my real problem:
>=20
> 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=20
> 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
>=20
> The problem is the fh_FdbMsgQuery call which doesn't seem to=20
> return the
> data as specified in the manual. Has anyone got any experience with =
=3D
> this
> call? Also, there is fh_FdbMsgQueryFilterNew function which is not
> described in the manual but works in apitst. I looked over The =3D
> Cassandra
> project and couldn't find a similar program. Have I missed=20
> someting? My
> manual is B0193YN, rev. C, from March 3, 2003.
>=20
> The other problem is ODBC and OLE*DB on Windows. I keep=20
> getting strange
> resultsets from them. Sometimes RecordCount is accurate but=20
> 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 =3D
> sometimes
> a table name or tag name and after another call there is no=20
> such field.
> Wierd! Is there anyone actually using OLE*DB connetion to=20
> AIM*Historian
> from PHP or ASP?
>=20
> I would be happy with any other solution to get to the data I=20
> need into
> my PHP or ASP or C or ....
>=20
> Thanks for you help, everyone!
>=20
> Ales
>=20
>=20
> =3D20
> =3D20
> ______________________________________________________________
> _________
> This mailing list is neither sponsored nor endorsed by=20
> Invensys Process
> Systems (formerly The Foxboro Company). Use the info you=20
> obtain here at
> your own risks. Read=20
> http://www.thecassandraproject.org/disclaimer.html
> =3D20
> foxboro mailing list: =20
> //www.freelists.org/list/foxboro
> to subscribe: =3D
> mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Djoin
> to unsubscribe: =3D
> mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Dleave
> =3D20
>=20
>=20
> Esta informaci=3DF3n es privada y confidencial y est=3DE1 dirigida =
=3D
> =3DFAnicamente a su
> destinatario. Si usted no es el destinatario original de=20
> este mensaje =3D
> y por
> este medio ha tenido acceso a dicha informaci=3DF3n, por favor=20
> elimine el
> mensaje. La distribuci=3DF3n o copia de este mensaje est=3DE1=20
> estrictamente
> prohibida. Esta comunicaci=3DF3n es s=3DF3lo para prop=3DF3sitos de =
=3D
> informaci=3DF3n y no
> debe ser considerada como propuesta, aceptaci=3DF3n ni como una =3D
> declaraci=3DF3n de
> voluntad oficial emanada de Profertil S.A. La transmisi=3DF3n=20
> de e-mails =3D
> no
> garantiza que el correo electr=3DF3nico sea seguro o libre de error. =
Por
> consiguiente, no manifestamos que esta informaci=3DF3n sea completa o =
=3D
> precisa.
> Toda informaci=3DF3n estar=3DE1 sujeta a alteraciones sin previo =
aviso.=3D20
>=20
> This information is private and confidential and intended for the =3D
> recipient
> only. If you are not the intended recipient of this message you are =
=3D
> hereby
> notified that any review, dissemination, distribution or copying of =
=3D
> this
> message is strictly prohibited. This communication is for information
> purposes only and shall not be regarded neither as a proposal, =3D
> acceptance
> nor as a statement of will or official statement from Profertil S.A. =
=3D
> and/or
> subsidiaries and/or affiliates. Email transmission cannot be=20
> guaranteed =3D
> to
> be secure or error-free. Therefore, we do not represent that this
> information is complete or accurate and it should not be=20
> relied upon as
> such. All information is subject to change without notice.
>=20
>=20
> =20
> =20
> ______________________________________________________________
> _________
> This mailing list is neither sponsored nor endorsed by=20
> Invensys Process
> Systems (formerly The Foxboro Company). Use the info you=20
> obtain here at
> your own risks. Read=20
> http://www.thecassandraproject.org/disclaimer.html
> =20
> foxboro mailing list: =20
//www.freelists.org/list/foxboro
to subscribe: =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
to unsubscribe: =
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
=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
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:
