Re: [foxboro] AIM*Historian connection on Windows
- From: "Johnson, Alex (Foxboro)" <ajohnson@xxxxxxxxxxx>
- To: foxboro@xxxxxxxxxxxxx
- Date: Thu, 4 Nov 2004 08:35:06 -0500
If you have AIM V3.2 or later, OLE DB is supported and it is supposed to be
better than ODBC.
I have to admit that I've used neither and am repeating what the developers
have told me. I'm not even certain of the differences.
Regards,
Alex Johnson
Invensys Process Systems
Invensys Systems, Inc.
10707 Haddington
Houston, TX 77043
713.722.2859 (voice)
713.722.2700 (switchboard)
713.932.0222 (fax)
ajohnson@xxxxxxxxxxx
-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On
Behalf Of Ales Vaupotic
Sent: Thursday, November 04, 2004 12: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:
