Exercise: PI SQL Client (OLEDB) and RTQP Configuration

Document created by kduffy on Sep 25, 2018Last modified by kduffy on Jul 1, 2019
Version 10Show 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 SQL Client connections to the PI SQL Data Access Server (RTQP) service.

 

Approach:

Using the following resource:

  • Not authorized to view the specified discussion 2659

As well as these additional resources:

 

Problem Statement:

Determine the correct connection string for the following scenarios:

 

1. Connecting to an AF Database named "AFDB1" on an AF Server named "AFSRV01" using Windows explicit login. The Windows domain username is "OledbUsers" and password is "5q1i5|=v|\|".

2. Connecting to an AF Database named "AFDB2" on an AF Server named "AFSRV02" passing the user's context via SSPI, setting the timezone to "(UTC+04:30) Kabul".

3. Connecting to an AF Database named "AFDB3" on an AF Server named "AFSRV03" passing the user's context via SSPI, setting the query context to query from 2018-10-01 as opposed to the current time.

4. Connecting to an AF Database named "AFDB4" on an AF Server named "AFSRV04" passing the user's context via SSPI, disallowing connections to be made with NetTcp.

5. Connecting to an AF Database named "AFDB5" on an AF Server named "AFSRV05" passing the user's context via SSPI, setting the timeout for connections to be 60 seconds and the timeout for query execution to be 900 seconds.

 

Have questions? Ask the community

When you are ready, compare your answers with the Solution: PI SQL Client (OLEDB) and RTQP Configuration

Attachments

    Outcomes