Thank you for that Alex. But the issue is retrieving data out of the archives without having to restore them on the AIM* server. I'm sorry I was not clear about that in my first e-mail. Cheers, Frits. -----Original Message----- From: Johnson, Alex (Foxboro) [mailto:ajohnson@xxxxxxxxxxx] Sent: Monday, 3 March 2003 14:26 To: foxboro@xxxxxxxxxxxxx Subject: Re: [foxboro] AIM* historian You can retrieve everything from AIM*Historian by using: 1) AIM*Inform 2) ODBC V1.x compliant applications 3) Oracle export 4) AIM*API 5) A variety of other tools including AIM*Explorer and I/A Series Report Writer In V3.2 of AIM*Historian, you can use OLE DB in addition to ODBC. Regards, Alex Johnson Invensys Systems, Inc. 10707 Haddington Houston, TX 77043 713.722.2859 (office) 713.722.2700 (switchboard) 713.932.0222 (fax) ajohnson@xxxxxxxxxxx For the latest information on ArchestrA, go to www.invensys.com/Archestra.html. -----Original Message----- From: Schouten, Frits JF [mailto:Frits.Schouten@xxxxxxxxxxxx] Sent: Sunday, March 02, 2003 3:43 PM To: Foxboro DCS Mail List (E-mail) Subject: Re: [foxboro] AIM* historian I'm surprised by the fact that nobody had anything to say about my question regarding retrieving information out of AIM* archives. Am I right in saying that archiving anything with AIM* is a waste of time because nothing can be retrieved from it anyway? Cheers, Frits. -----Original Message----- From: Schouten, Frits JF [mailto:Frits.Schouten@xxxxxxxxxxxx] Sent: Monday, 17 February 2003 13:52 To: Foxboro DCS Mail List (E-mail) Subject: [foxboro] AIM* historian Hi All, here we are archiving, on a weekly basis, our AIM* historian with the tools available. Putting it on CD goes fine too being just around 600Mb. That's all fine and dandy. Now we have a need to examine a few weeks worth of data from some time ago and have absolutely no tools available to make any use of the archive. Is there a way to view these archives without having to restore it on a Foxboro system. We just want the numbers out of these archives. There is no need to view them in a trend. Number crunching is the game of the day. It there a way to import those archives in say MS Access or so? Any help would be much appreciated. Frits Schouten Process Computing Department New Zealand Steel Phone: +64 +9 375 8111 ext 5261 Email: Frits.Schouten@xxxxxxxxxxxx EOM NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message. _______________________________________________________________________ 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 EOM NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message. _______________________________________________________________________ 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