Re: so it is a bit expensive to buy the whole thing just to get the ODBC
drivers
If you mean that you think you have to buy all of PIMS to get Datalink, you
do not. You can buy it separately. Though the Datalink and FoxExplorer combo
is a pretty good price.
Re: 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?
That is correct. An Informix ODBC driver can only see Informix tables. The
SAM files are not part of Informix. The only access to them is through
AIM*API, FoxAPI, or the Historian's API.
Datalink provides ODBC support for all data in the legacy/data/old/IA
historian.
At least give you Foxboro Account Rep a call and see what Datalink costs and
what the combination costs. I think you might be surprised (to the good
side). Unless I'm mistaken (and it does happen) we now offer concurrent
licensing so you can buy a few and let everyone have occasional access.
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]>
-----Original Message-----
From: Murray, Steve [SMTP:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 1:20 PM
To: 'Foxboro DCS Mail List'
Subject: RE: ODBC and Legacy Historian
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]
-----------------------------------------------------------------------
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]
