Solution: PI OLEDB Provider Configuration

Document created by kduffy on Sep 26, 2018Last modified by kduffy on Jul 2, 2019
Version 3Show Document
  • View in full screen mode

This document contains the answers to the Exercise: PI OLEDB Provider Configuration. The screenshots in this document reference the PI OLEDB Provider User Guide pages 13-19.

 

1. Connecting to a PI Data Archive named "PISRV01" using explicit login. The username is "OledbUsers" and the password is "5q1i5|=v|\|"

answer: Provider=PIOLEDB.1;Password=5q1i5|=v|\|;User ID=OledbUsers;Data Source=PISRV01;Persist Security Info=True

2. Connecting to a PI Data Archive named "PISRV02" passing the user's context via SSPI, enabling level 3 logs to a file named "C:\temp\oledblogs.txt"

answer: Provider=PIOLEDB.1;Data Source=PISRV02;Persist Security Info=False;Integrated Security = SSPI;Log Level=3;Log File=C:\temp\oledblogs.txt

 

3. Connecting to a PI Data Archive named "PISRV03" passing the user's context via SSPI, disabling asynchronous PISDK calls

answer: Provider=PIOLEDB.1;Data Source=PISRV03;Persist Security Info=False;Integrated Security = SSPI;Sync Calls=True

4. Connecting to a PI Data Archive named "PISRV04" passing the user's context via SSPI, setting the timezone to UTC

answer: Provider=PIOLEDB.1;Data Source=PISRV04;Persist Security Info=False;Integrated Security = SSPI;Time Zone=UTC

Attachments

    Outcomes