Connecting to the OLE DB Provider

To connect an OLE DB client to a Historian server on a local connection (both software packages are on the same PC), all that is required is the following line:

Provider=iHOLEDB.iHistorian.1

To connect an OLE DB client to an Historian Server on a remote PC, the following string should be used:

Provider=iHOLEDB.iHistorian.1;Persist Security Info=False;USER ID=[Username];Password=[Password];Data Source=[Target];Mode=Read

Replace Target with the network name of your Historian server, Username with your Historian server user name, and Password with your Historian server password.

IMPORTANT: Clients using the OLE DB provider must initialize COM in Apartment threaded mode.

See Also

Historian Interactive SQL Application

Historian and the Proficy Real Time Information Portal SQL Client

Crystal Reports

Microsoft Excel XP

Microsoft Data Transformation Services

Linked Servers in Microsoft SQL Server

VisiconX

Visual Basic and ADO

Oracle

How Do I

work with Clients

use the Samples

build a Query