Exercise: PI OLEDB Provider Configuration

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

Objective: The goal of this exercise is to demonstrate understanding of how to set certain parameters at the connection level for PI OLEDB Provider connections.

 

Approach:

Using the following resource:

  • Not authorized to view the specified discussion 2655

As well as these additional resources:

 

Problem Statement:

Determine the correct connection string for the following scenarios:

 

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

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"

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

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

 

Have questions? Ask the community

When you are ready, compare your answers with Solution: PI OLEDB Provider Configuration

Attachments

    Outcomes