6/27/2019 0 Comments Ovation Historian Ole Db ProviderMicrosoft OLE DB Provider for Oracle (oracle 10g) Microsoft ODBC Provider for Oracle (oracle 10g). Does anyone have experience with using the 'Ovation Process Historian OLE DB Provider' within BIDS? This particular provider works well from within. Unanswered 1 Replies. The Historian Server 2014 for System Platform course is a 2-day, instructor-led class designed to provide. Outlines Historian Server OLE DB provider and explains its query syntax. Section 2 – Retrieval Modes. This section describes Historian Server retrieval modes and how to specify retrieval mode in the. I'm trying to get data from a WonderWare historian database on all tags in the database. There is already a table containing all the tags, so I would like to use a subquery to select all of the tag names. I'm getting an error w.r.t this subquery. ![]() My sql statement: The error I am receiving is the following: Which I guess means that it isn't being executed properly. I've also tried using openquery, but then I get other errors related to the subquery unable to discern 'schema' information about the Tag table: This was the excerpt changed:
cbcoutinhocbcoutinho
2 Answers![]() Historian Server is not a normal SQL Server database. It's historical views get data from the INSQL linked server. INSQL has some special rules that are documented in HistorianConcepts.pdf.
trailertrailer
TarazTaraz
Not the answer you're looking for? Browse other questions tagged sql-serverwonderware or ask your own question.
0 Comments
Leave a Reply. |