7EN02-0290-11

Query Module

The Query module retrieves logged data from the ION database and makes it available to ION clients such as Vista. This module is only available in the VIP.

Module icon

Overview

Query modules work independently of the Log Inserter, therefore improving the overall performance of system data access.

Inputs

The Query module has no programmable inputs.

Setup registers

Connection String

This register specifies the SQL Server 2000 or MSDE 2000 database connection string that the Query Server uses to connect to the ION database. When setting up this register in Designer, the Connection Properties dialog box displays the following option boxes: Provider, Data Source or DSN, Initial Catalog, User ID, Password, and Connect Timeout.

Provider

This register lets you select the type of database the Query module uses to connect to the ION database:

Provider Description
LSProvider.SQLOLEDB Access to SQL databases (Schneider Electric type)
LSProvider.MSDASQL Access to Sybase SQL databases (Schneider Electric type)
SQLOLEDB Access to OLEDB/SQL Server databases (non-Schneider Electric type)
MSDASQL Access to Sybase OLEDB/SQL Server databases (non-Schneider Electric type)

Data Source or DSN

This register defines the ODBC data source (for non-Sybase SQL databases) or DSN (for Sybase SQL databases) the Query module uses to connect to the ION database. For non-Sybase SQL databases a typical value for Data Source might be ComputerName\ION, while for a Sybase SQL databases a typical value for DSN might be ComputerName_PEGASYS (where "ComputerName" is the network name of the computer where the ION database resides).

Initial Catalog

This register applies to non-Sybase SQL databases only. This option is disabled for Sybase SQL databases. Initial Catalog defines the name of the database table; for example, “ION_Data”.

User ID

This register applies to non-Schneider Electric type databases only, and defines the user ID you enter to access the database. This option is disabled for Schneider Electric type databases, since Designer uses the Power Monitoring Expert login credentials to access the database.

Password

This register applies to non-Schneider Electric type databases only, and defines the password you enter to access the database. This option is disabled for Schneider Electric type databases, since Designer uses the Power Monitoring Expert login credentials to access the database.

Connection Timeout

This register defines the time limit (in seconds) for connecting to the database, before timing out.

Output registers

Query Register

This register links to the setup information you entered in the Connection String setup register, so you can link a Data Log Viewer object to it in Vista.

Detailed module operation

To create and set up a Query module, open the QUERYSERVER node in Designer. Modify the Connection String register settings to the values needed to connect to the database. After creating and setting up the Query module in Designer, create a Data Log Viewer object in Vista to view the data, then link the object to the Query module’s Query Register.

QR Code is a registered trademark of DENSO WAVE INCORPORATED in Japan and other countries.

Was this helpful?