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:
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.