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