Skip navigation
Log in to follow, share, and participate in this community.

Recent Activity

cbartman
I have an Excel workbook that queries PI OLEDB by creating an ADODB connection and opening an ADODB recordset in VBA.   The code used to work fine for several months, but for some reason has recently stopped working and I am getting an error message, shown below, that I haven't been able to resolve: Run-time error '-2147467259 (80004005)': [PI… (Show more)
kduffy
Click to view contentThe first release of the RTQP Query Engine and PI SQL Client have very few performance considerations to keep in mind when writing queries.   With PI OLEDB Enterprise being a client-side bandwidth-optimized query engine separated from the AF Server's backend PIFD SQL database by the AFSDK, there were numerous performance considerations to keep in…
LaineTedder
I can successfully write to the tag using Student01 account from SQL Commander when using PI OLEDB Provider connection.   However, when I try to do similar from MSSQL  using a linked server and using current user security context I receive the below error Query Example SELECT * FROM OPENQUERY([PIOLEDB], 'INSERT piarchive..picomp2 (tag, time,… (Show more)
LaineTedder
When trying to complete Exercise 2 PI SQL Client (OLEDB) and RTQP Configuration I cannot connect or ping referenced AF servers AFSRV01 - 05. I can of course connect to the local AF instance on the server I am working on
BarryHu
In Lesson 3, Understand the basics of RTQP Engine schema, there is a step "Add GetSummaries...". When execute the code I got the attached error. May someone explain why it happens? Thanks. Also insert image does not seem to be working. When I choose the file and click Insert, nothing happens....
norman_soriano
Click to view contentHi,   could anyone help me to find out what is the problem on my pi sql client? I cant able to create new schema. it is disabled on my sql commander.    Thank you in advance!!  
Basavakumar_Jigalur
Hello Team,   I am starter to the PI SQL topics. I understood that we need enter all the details via connection string for PI OLEDB provider before we connect to PI DA and get data. But I am not clear, where to enter those scripts. Regarding UDL file, I understood how to create it and what all to fill in, but not sure how would that be utilized.… (Show more)