Hi Alex,
We are presently using the ODBC drivers that came with the original Data
for Windows & its replacement PIMS.
We use several Excel spreadsheets for our daily and monthly reports that
use the ODBC portion of the PIMS suite. The daily and monthly reports get
mostly reduction data, some manual data entry data, and a little bit of
sample data.
I also wrote an Excel trending app that gets sample data with a sql call
like:
"SELECT Time, Value FROM Sample/" & fHistorian & ".Current
WHERE(Source='" & TagName2 & "' AND Time BETWEEN " & QueryStart & " AND " &
QueryEnd & ")"
All of these Excel spreadsheets make use of ODBC calls to the historian,
but only one Excel user is using the live OM data links. Very few people
are using the Data for Windows portion of the PIMS, and so it is a bit
expensive to buy the whole thing just to get the ODBC drivers.
I know the extended sam files are "outside" the Informix database, but
does this mean a generic ODBC driver would not be able to access them like
the Foxboro provided ODBC can? I did not think it would be easy, but I was
hoping it would at least be possible . . .
Thanks,
Steve Murray
-----Original Message-----
From: Johnson, Alex (Foxboro) [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 11:10 AM
To: Foxboro DCS Mail List
Subject: RE: ODBC and Legacy Historian
Steve,
Re: ODBC and Informix and the legacy historian
AIM*Datalink can do that through either the old historian or AIM*. You can
get Datalink and Explorer and have a good time with Excel and
live/historical trends. There is a package price for the two of them.
Re: ODBC and Informix
Several paper companies have Informix setup to support ODBC as part of the
work our Pulp and Paper folks do.
However, be aware that Informix holds only reduction data and this might not
be what you want.
Hope this helps.
Regards,
Alex Johnson
10707 Haddington
Houston, TX 77043
713.722.2859 (office)
713.722.2700 (switchboard)
713.932.0222 (fax)
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
This transmission is for the intended addressee only and is confidential
information. If you have received this transmission in error, please delete
it and notify the sender. The contents of this E-mail are the opinion of the
writer only and are not endorsed by ASARCO Inc. unless expressly stated
otherwise.
-----------------------------------------------------------------------
This list is neither sponsored nor endorsed by the Foxboro Company. All
postings from this list are the work of list subscribers and no warranty
is made or implied as to the accuracy of any information disseminated
through this medium. By subscribing to this list you agree to hold the
list sponsor(s) blameless for any and all mishaps which might occur due to
your application of information received from this mailing list.
To be removed from this list, send mail to
[EMAIL PROTECTED]
with "unsubscribe foxboro" in the Subject. Or, send any mail to
[EMAIL PROTECTED]
