Starting the Historian Interactive SQL Application

About this task

When you start the application, you can log in to the default server or another Historian server.

To start the Historian Interactive SQL application, follow these steps:

Procedure

  1. From the Start menu, select Programs > Historian 6.0 > Historian Interactive SQL.
    Important: In Windows 10 and Windows 7, the first time you use ihSQL.exe, you may need to select Run As Administrator. If you do not do this the first time you use ihSQL.exe, you may not be able to log in. After this, you do not need to select Run as Administrator again.
    The Historian Interactive SQL Login dialog box appears, as shown in the following figure.
    Figure: Historian Interactive SQL Login Dialog Box
  2. Do one of the following:
    • Select a server from the drop-down list.
    • Click Browse to open the Historian Servers dialog box to select a server.
  3. Enter a user name, password, and domain, if any.
    If no username and password is specified, the currently logged-in username and password is used.
    Note: You must enter a username and password when running on Windows 9x.
    • If the username or password is incorrect, a message box appears. Click OK and try to log in again.
  4. Click OK.
    You can now proceed with all Historian Interactive SQL functions or tests.

Results

The session begins with the default values for the SET variables. See SET Variables for a table that lists the SET variables with their default values.

For more detailed information on the supported SQL syntax that you can use in the Historian Interactive SQL application, refer to Supported SQL Syntax.