Cannot Get Historian OLE DB Provider Data

About this task

If you cannot get data and you suspect there is a security problem with Historian, follow these steps to confirm that the Historian OLE DB Provider is working:

Procedure

  1. Open the Historian Interactive SQL application and connect to the OLE DB Provider.
  2. Enter the following command:
    SELECT * FROM ihQuerySettings
  3. Click the Execute Query button.
  4. Confirm that data appears in the bottom half of the window:
    • If one row of data returns, then the provider is installed and working correctly, but you may have security problems between the provider and the server. You must use a valid Historian username and password.
    • If no rows return, then there is a connection problem between the client and the OLE DB Provider.

Results

The ihQuerySettings data is internal to the OLE DB Provider and does not use any Historian security. Browsing the tables and columns also is unaffected by Historian security and is another way to confirm the connection between the client and provider.