Home : Products : Hach WIMS : Interfaces : Hach WIMS Direct Server-Side Interface to Narrow Format OLEDB Source : Documentation : Topics specific to the operation of this interface : AspenTech IP21 Configuration with the Narrrow Format OLEDB interface (Q12160)
Q14411 - INFO: AspenTech IP21 Configuration with the Narrrow Format OLEDB interface (Q12160)

 The Narrow Format OLEDB interface (Q12160) can be used with IP21 by AspenTech.  

 Version Tested: 7.3.0.2 as of 01/27/2017

Setup:

IP21 logs data to an ODBC compliant database.  In order for the interface to connect an ODBC Connection must be created on the Interface PC:

The interface then uses the Microsoft OLE DB Provider for ODBC (MSDASQL) to connect to the ODBC DSN.  Make sure to set the DBMS type to IP21 as this allows the interface to know the date format, etc...

Set the Connection Alive Testing Strategy to Custom with a query of "SELECT * FROM IP_ANALOGDEF"

Source Data Example:

Connection String: Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User ID=FU4WIMS;Data Source=IP21

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/27/2017 11:57 AM.
Last Modified on 1/27/2017 12:31 PM.
Last Modified by Scott Dorner.
Article has been viewed 7192 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article