How are you connecting to SQL Server from the ProcessBook display? Are you using ADODB objects? I believe the ProcessBook display should rely on single sign-on via a trusted …

Can you test the linked server in SQL Server Management Studios? If it does not connect, we should verify the linked server settings as well as verify a connection in the PI Server Message …

Jun 2, 2017 · My Server is 2012 R2. It is running SQL Server 2014 Standard Edition and hosts the Asset Framework Server (2016 R2) Database also. The upgrade completed successfully. …

A persist string must be created from an initial connection to the Server before disconnection. I have not tried to restore a persist string without a connection, but suspect it will not work.

While uploading historical event frame from SQL server Database to AF Server using C# code it gives timeout after I uploading some, the error is listed below {"This request operation sent to …

Linq-To-SQL (Linq to MS SQL Server) is very very usefull when using a MS SQL Server database. It's very easy to extract, update and insert data using objects. No need to create …

There is an intensive query on our SQL database that is blocking all access on the SQL server and AF databases, it is an insert into a table named "#tblElementHierarchy2".

2) Based on the question above the offended query is below, this query takes about 8 minutes to run in Sql Commander (the tool that comes with PI, so is probably not really a linked server …

Depends what you're modelling in your SQL Database, there may not be a direct equivalent but perhaps a different way of representing the data model. For example, AF allows you to have …

You're just using the query processor in SQL server to present an interface that the relatively dumb (from a connectivity management standpoint anyway) EG client can easily understand. …