Database Connection Editor
SECTION 12 Databases
181
SECTION 12
Databases
CX-Supervisor Database facilities provide fast, transparent access to many
different data sources, via a database technology called ADO. Database
design is not covered here, as it is a large subject explained fully in any of the
many books available. It is assumed that developers using these database
facilities have a working knowledge of databases. Comprehensive Database
Script Functions allow complete database access.
The data sources which can be accessed depends on the Data Providers
installed, but may include:
•
MS-Access
•
MS-Excel
•
Visual FoxPro
•
dBase
•
ODBC for Oracle
•
Paradox
•
SQL Server
•
Text files (in TXT and CSV format)
12-1
Database Connection Editor
The Database connection editor in the Development Workspace, enables
users to create Connections, Recordsets, Field association, Parameter
association and Schema objects in a familiar Tree View (hierarchical) format,
using the popup menu.
This editor is unique in CX-Supervisor, in that actual database connections
can be tested online in the Development Environment. The ability to connect
online also has the added benefit of providing assistance in creating objects
lower down in the hierarchy. This editor has been designed to enable a large
proportion of the database functionality, to be performed automatically (i.e.
without the need for Script functions), although a comprehensive set of
Database Script functions are available.
Содержание CX-Supervisor
Страница 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Страница 3: ...Copyright Notice 2...
Страница 16: ...15...
Страница 17: ...16...
Страница 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Страница 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Страница 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Страница 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Страница 181: ...Data Logging SECTION 11 Data Logging 180...
Страница 201: ...Examples SECTION 12 Databases 200...
Страница 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Страница 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Страница 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Страница 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Страница 271: ...Data Logging SECTION 20 Best Practices 270...
Страница 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Страница 277: ...Appendix B Frequently Asked Questions 276...
Страница 296: ...Appendix B Frequently Asked Questions 295...
Страница 297: ...Appendix B Frequently Asked Questions 296...
Страница 298: ...Appendix B Frequently Asked Questions 297...
Страница 299: ...Appendix B Frequently Asked Questions 298...
Страница 333: ...Revision history 332...