Download ECHO OLE DB Data Provider User Guide

iii
Contents
Chapter 1 Introduction
Product Overview .................................................................................................... 1-2
Introduction to OLE DB .......................................................................................... 1-3
OLE DB Architecture ....................................................................................... 1-3
OLE DB Data Provider for ECHO ................................................................... 1-5
Chapter 2 Installation
Installation / Uninstallation Guidelines.................................................................... 2-2
Chapter 3 Configuration for Data Access
Configuration Attributes .......................................................................................... 3-2
ECHO OLE DB Specific Attributes......................................................................... 3-3
ECHO OLE DB Login Dialog Box ......................................................................... 3-5
Universal Data Link (UDL) ..................................................................................... 3-6
Creating a UDL File ......................................................................................... 3-6
Editing with the Data Link Properties Dialog Box ........................................... 3-7
Connection String Format............................................................................... 3-10
Setting Maximum Processing Time for Queries ............................................. 3-10
Chapter 4 Supported ANSI SQL 92 (Subset)
SELECT Statements ................................................................................................ 4-2
INSERT, UPDATE, DELETE, CREATE/DROP DATABASE Statements ........... 4-4
CAST Operator ........................................................................................................ 4-5
Chapter 5 Catalogs and Tables
Catalog Usage .......................................................................................................... 5-2
CREATE DATABASE / DROP DATABASE Statements...................................... 5-3
Table Structure- ECHO Catalog .............................................................................. 5-4
Table Structure - Historians Catalog........................................................................ 5-7
Supported Data Types............................................................................................ 5-14
Supported Time Stamp Formats............................................................................. 5-15
Examples of Other Statement Use ......................................................................... 5-16
Simple Expressions......................................................................................... 5-16
Simple Table Queries...................................................................................... 5-16
NULL Values.................................................................................................. 5-17
DISTINCT ...................................................................................................... 5-17
TOP n.............................................................................................................. 5-17
GROUP BY, HAVING................................................................................... 5-17
ORDER BY .................................................................................................... 5-17
Inner Joins....................................................................................................... 5-17
Nested Queries................................................................................................ 5-18
Subqueries....................................................................................................... 5-18
UNION ........................................................................................................... 5-18
INSERT INTO SELECT ................................................................................ 5-18