OLE DB Access to History Information

I would like to access/extract OIT logged History data by means of the “ABB OLE DB Provider for HT”.

I have consulted the standard available documentation, but have not been able to find the OLE DB functionality described.

What I need to do is something like:
SELECT * FROM HistoryTable WHERE ObjectName=”MyObject” AND TIME>”2002-06-28 00:00:00”;

Can anyone point me to some documentation, or maybe some code/SQL samples that shows/explains how to accomplish the above?
I think that I will manage to create a connection via the OLE DB Provider, so my main worry is naming conventions and table structures.

System: PPA 2.1
Preferred language: VB

Best regards
ABB A/S - INPC - Denmark
Jesper Bolding

Add New Comment

Jesper Bolding   

asked 1 year ago



I found the document 3BSE025995_EMethods_Book.pdf (section 18)in <PPA installed dir>\doc useful.


Edgar Jellum   

answered 15 years ago


Add New Comment

Get weekly AKS updates

Partner Exclusive Webinars


> – Login to the partner portal to register

Points Redemption Program - Redeem your points for ABB training, Bluetooth speakers and mugs. Terms and conditions >

Earn points when you refer a friend
AKS Referral Program is "Live" - Learn more

AKS Experts

Ask Ronny Lindström   

Rank: 17

ABB Service Engineer

Ask Govindaraj   

Rank: 10

Working in ABB India Operation Center. Have Project engineering and commissioning experience in ABB 800xA, Freelance, AC500.

Ask Flavio Mussolin   

Rank: 4

ABB AVP, Senior Electronic and Automation Engineer with over 30 years of experience in the field of process automation automotive, pharmaceutical, hollow glass, steel and rolling.

Ask nikismith   

Rank: 247

I have been a part of the Recording & Control Factory team for 17 years in total, having spent a number of years as a repairs technician withi the manufacturing department, but being in my current role for 9 years now.

Ask MMM   

Rank: 5

ABB PA CT Technical Support

Ask Dieter Henkel   

Rank: 19

Ask Rob Lyon   

Rank: 2

info@lymac.co.nz I'm an independent DCS software and commissioning engineer with extensive experience in 800xA and other ABB products. I've worked in almost every corner of the world and still haven't seen it all.

Ask Harsha.D   

Rank: 7

Tech.Support,software and commisioning engineer with Proficient knowledge in 800xA and its products, RNRP,Networking in general.

Ask WvanWees   

Rank: 6

I'm a senior service engineer working for ABB in The Netherlands.

Ask kstoilov   

Rank: 11

Control System Engineer: 800xA, Compact 800, AC500, AC31-50, Advant Master, Simatic, AC&DC Drives 11 years worked for ABB - Control Systems

Ask Stefan Stromqvist   

Rank: 1

I joined ABB in the year of 1994 and has since 1999 been working as a Service & Support Engineer at BU Control Technologies in Västerås, Sweden. My areas of expertise are: 800xA Base, 800xA for Advant Master, Information Management, operating systems, RNRP and Ethernet comms/networking in general.

Ask Sumit Gargav   

Rank: 3

I have worked with Freelance in majority, with 800xA FD and Melody system partly. Also had opportunity to work with Protocols - HART,Profibus,FF & Modbus.