Re: [foxboro] AIM*Historian connection on Windows
- From: "Loiselle, Marc-Andre" <MLoisell@xxxxxxxxxx>
- To: "'foxboro@xxxxxxxxxxxxx'" <foxboro@xxxxxxxxxxxxx>
- Date: Thu, 4 Nov 2004 09:14:20 -0500
There is a good example of usage of the AIM* ODBC driver with Visual Basic
and the DAO library (that works) in AIM*DataLink User's Guide (B0193YJ rev
B), section 10. As mentioned previously, the "Events" database should be
used to get alarms.
There is an example of VB program using the AIM* OLEDB provider on the
AIM*3.2 CD in the directory win\ExamplePrograms\ADODB.
Good luck
-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On
Behalf Of Ales Vaupotic
Sent: Thursday, November 04, 2004 1:21 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] AIM*Historian connection on Windows
Jim,
Pan, Jim wrote:
>I never used AIM*API function calls, but I did use AIM*ODBC for other
>applications to query event messages from AIM*Historian.
>
>The first thing I would do is to check the "Logging Msgs" field of the
>message Names (such as ALARMMESG, OPRACTION, and SYSMONMSG). Setting
>the field to "Yes" will make these event messages available to ODBC
>access.
>
>The next I would do is to test the ODBC connection with MS Access. You
>need to define a new DSN to access the "Event Messages" database, not
>the "Message" database. Make a linked table from Access to
>AIM*Historian using this "Event Messages" ODBC connection and see if
>you can get any event messages from Access Query.
>
>
>
I have done that already and it only works in Access 97. Even there with
some minor hickups. With any other tool (Office XP or 2003, VB6, Delphi,
ASP, PHP, VC) which offers ODBC connection I can't connect to the
source on my machine. Usually the driver fails with "Catastrophic
Failure" message. With OLE*DB I got a bit closer but there was the other
problem I described.
>Jim Pan
>Lifetime Learning Center
>Houston
>
>
>
Can you post the version of software and operating system you work with?
Ales Vaupotic
AMI
Ptuj, Slovenia
_______________________________________________________________________
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
_______________________________________________________________________
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:
