Exercise: PI OLEDB Enterprise 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 Enterprise 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 AF Server named "AFSRV01" using Windows explicit login. The Windows domain username is "OledbUsers" and password is "5q1i5|=v|\|"

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

3. Connecting to a PI AF Server named "AFSRV03" passing the user's context via SSPI, and when an error message is encountered for a value, it's embedded into that cell in the result set instead of erroring the query

4. Connecting to a PI AF Server named "AFSRV04" 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 the Solution: PI OLEDB Enterprise Configuration

Attachments

    Outcomes