Log in to follow, share, and participate in this community. I have the following query: Select erc.Value as [ZONE] , el.Name as [LINE] from [AFDB].[EventFrame].[EventFrame] ef INNER JOIN [AFDB].[Asset].[Element] el ON el.ID = ef.PrimaryRefer... Is there any way at all currently to use named or unnamed parameters through PiSysOleDB (@pwhaterer, ? - unnamed, :pwhatever)? for Data.Interpolated.StartTime and EndTime? so that I can produce an ad-hoc report on AF ... Take a look at the SQL injection entry on Wikipedia, under the heading "escaping". I'd like to avoid potential SQL injection attacks in my coding of OleDB with the PI server. If that can be done with ... Are there any good walkthroughs of exposing PI as a Linked Server? (Too lazy & busy to have a look ) Particularly interested on example queries combining data from PI Linked Server and the host SQL Server. Hi I'm trying to figure out why I get the following message when using the PI OLEDB Provider in a 64 bit Visual Studio project: "The 'PIOLEDB.1' provider is not registered on the local machine." I... I have the following setup: -Win2k8 R2 (x64) -PI 22.214.171.124 -PI OLEDB x86 - IIS 7.5 - .NET 4.0 / Visual Studio 2010 I have created a WCF services, which accepts requests for data input/output from PI... Data is updating in primary PI server (2012 version ) but not in secondary pi server for specific point source all most all tags around 300. When I have observed in logs I found below message. Inserting overf... Select top 50 * from [MASTER].[ELEMENT].[Attribute] ea INNER JOIN [MASTER].[ELEMENT].[ARCHIVE] a ON a.ATTRIBUTE= ea.ID and ELEMENT = 'XXXXXXX' and NAME like '%7-7%' Where a.TIMESTAMP BETWEEN '04/... Hi, I am trying to install OLEDB Enterprise 2017 R2 and I have AF 2018 SP2, but i am getting error as below. Can anyone tell tell why i am getting this AFclient version error. Regards, Ritu Hello Experts, I am having an issue with a SQL query using PI OLEDB. I have two tags, the first one has int values and the second has a string value. The timestamps are the same for both tags. ... Hello, I notice that the function timeEq includes the duration of questionable values, even if we filter the questionable values in the WHERE clause. Is there any way to make the function timeEq, ... I am connecting to JDBC 2019 with no specified properties. I get this warning message for PI: com.osisoft.jdbc.common.DriverImpl acceptsURL SEVERE: Invalid sub-protocol provided in jdbc:pioledb://dasName/Data... I need to test real time data access from PI Server. For this I need to load data into PI Server. What tools or approaches can I use to upload data into PI Server I'm working with some relatively discrete laboratory analysis data that is being stored in PI at the same time for multiple attributes. The current GetSampledValues only allow for iteration over time ranges with times... I am trying to get range for "Dust" Attribute and sampled data for "PF10" attribute for a timestep of 20s. Below snap shows archive data for both the attributes. Can anyone help me with syntex for finding range and s... Was wondering if the Transpose function can be used to transpose a view? Hi Friends, I have set up a query to read the data from Pi Server into SQL Server and the query works fine. However, when I save this query as a SQL Server Integration Service Package and run the same, ... I am having trouble configuring our RTQP server and user authentication the way i want to. In reading through the admin guide it only provides instructions for adding a mapping/trust for the ... Hello Everyone! I have configured digital tags, which values I can see good in Archive editor but in SQL Commander it is showing incorrect please check below screenshots. PI SQL Commander: ... What is the case format in PI SQL Commander? Thank you.