Re: [foxboro] AIM*AT access through ODBC

 I have a code that is used in Excel Macro to fetch data from AIM*
historian.
Hope it helps u.

----------------------------------------------------------------------------
------------------------------------------------
fin = ans + var1 + mois + var1 + jour + var2 + "05" + var3 + "00" + var3 +
"00"

debut = ans1 + var1 + mois1 + var1 + jour1 + var2 + "06" + var3 + "00" +
var3 + "00"


Connection = "dsn=AIM AT Historian Database;AP=AWNT01"
conid = sqlopen(Connection)

On Error GoTo fin

SQLString = "SELECT time, average FROM hist01.Reduction/reduc_01 WHERE
(Source='HEATING_2_IN:II3604.PNT') AND (time between {ts'" & debut & "'} AND
{ts'" & fin & "'}) ORDER BY time DESC"
    numcolumns = sqlexecquery(conid, SQLString)
    numrows = sqlretrieve(conid, Worksheets("sheet2").Range("B43"), , ,
False)
----------------------------------------------------------------------------
---------------------------------------------------------------------
Where fin and debut are start and end time for fetching values.

reduc01 - reduction group name
hist01 - historian name
HEATING_2_IN:II3604.PNT - Compound:Block.Parameter
AWNT01 - Station name on which this program is run.


Regards,

Sekar

>  -----Original Message-----
> From:         foxboro-bounce@xxxxxxxxxxxxx@CORP   On Behalf Of "Control y
> Automatizacion (Rodolfo Piedra)" <rpiedra@xxxxxxxxxxx>
> Sent: Thursday, August 22, 2002 5:50 PM
> To:   foxboro@xxxxxxxxxxxxx
> Subject:      Re: [foxboro] AIM*AT access through ODBC
> 
> 
> Can someone provide an example using visual basic and MS-SQL,
> 
> Thanks in advance, regards,
> 
> Rodolfo Piedra
> Control y Automatización SA
> rpiedra@xxxxxxxxxxx
> 
> 
> ----- Original Message -----
> From: <sturner@xxxxxxxxxxxxx>
> To: <foxboro@xxxxxxxxxxxxx>
> Sent: Thursday, August 22, 2002 3:29 PM
> Subject: Re: [foxboro] AIM*AT access through ODBC
> 
> 
> >
> >
> > We use AIM * ODBC with Lotus Notes for some production databases, and it
> > works well.   We have used Crystal Reports with ODBC with some success.
> >
> >
> >
> >
> >                     "Balasubramaniam, Satishkumar"
> >                     <Satishkumar.Balasubramaniam@Inv       To:
> foxboro@xxxxxxxxxxxxx
> >                     ensys.com>                             cc:
> >                     Sent by:                               Subject:
> [foxboro] AIM*AT access through ODBC
> >                     foxboro-bounce@xxxxxxxxxxxxx
> >
> >
> >                     08/22/2002 09:19 AM
> >                     Please respond to foxboro
> >
> >
> >
> >
> >
> >
> >
> > Appreciate if anyone can show me some links on AIM*AT access through
> ODBC!
> > Looks like it is a bit different from the normal ODBC as I get an error
> > while doing a SQLPrepare for an update command!
> >
> > Thanks & Regards,
> > Satish
> >
> >
> >
> > _______________________________________________________________________
> > 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:             http://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:             http://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:             http://www.freelists.org/list/foxboro
> to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
> to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
>  

-- No attachments (even text) are allowed --
-- Type: application/ms-tnef


 
 
_______________________________________________________________________
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:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: