PI Admin

Hi, Do you have the PI ODBC Client installed? It's part of the Data Access Pack. If you do then follow these steps:
Add a new DataSource in Control Panel->Administrative Tools->DataSources (ODBC). Your data source can be a User DSN if just you will be using it, or system DSN if everyone that uses the computer needs access to it.
Add a datasource that uses the PI-ODBC driver.
You'll need to provide a name for your datasource e.g. PI, and the PI Server name too. You can specify several other options at this stage - see the docs.
Once the datasource is created then you can use it in your application.
The following query will return all attributes for the tag sinusoid:
 
select * from pipoint where tag = 'sinusoid'
Tables available through the driver include:
 
 

• PIpoint  The PI point database.
• PIcomp  The PI System archive.
• PIinterp  The PI System archive viewed as consisting of rows with evenly spaced times.
• PIavg  The archive viewed as consisting of time weighted averages.

 
Hope this helps a little. It's no substitute for the fine documentation.

PIAdmin