![background image](http://html1.mh-extra.com/html/omron/cx-supervisor/cx-supervisor_user-manual_744211184.webp)
Configuring a Connection
SECTION 12 Databases
183
12-2-1-3 Connect on Application Start-up
The checkbox 'Connect on Application Start-up' provides the option of
automatically connecting to the Database when the Runtime application is
started.
12-2-1-4 Advanced
Shows the Connection String dialog box, allowing the automatically generated
connection string to be manually edited.
12-2-2 Testing Connections in the Development Environment
A connection to a Database can be made in the Development Environment by
selecting the required Connection in the Tree View and then selecting the
right-menu option 'Connect'. If a Connection contains Recordsets that are set
to auto open, these will also be opened by the 'Connect' option. If all goes well
and a valid connection is made, the Database Connection Icon will be adorned
with a 'lightning bolt'. If not, then this is probably due to an error in the
'Connection String'.
12-2-3 Database Errors
A detailed description of what type of error occurred (supplied by the
underlying Data Provider) can be viewed, by clicking that the right-menu
option 'Show Last Error'. Whenever an error is generated by a Data Provider a
description of the error and its source will be displayed in a Dialog. The 'Show
Last Error' option is specific to each Connection.
Example: The following error was generated by the 'Jet Database Engine'
(due to a typo in the Database name):
12-2-4 Database Connection String dialog box
Connection to a Database is performed by means of a 'Connection String'.
Because different Data Providers require different information to connect you
to a data store, these strings can be quite complex and cumbersome. For this
reason CX-Supervisor will automatically create a valid connection string for
your selected data source (if it's supported). This string can be viewed and
modified via the Connection String dialog box shown below, when 'Advanced'
is pressed on the Add/Modify Database Connection dialog box.
Summary of Contents for CX-Supervisor
Page 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Page 3: ...Copyright Notice 2...
Page 16: ...15...
Page 17: ...16...
Page 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Page 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Page 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Page 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Page 181: ...Data Logging SECTION 11 Data Logging 180...
Page 201: ...Examples SECTION 12 Databases 200...
Page 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Page 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Page 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Page 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Page 271: ...Data Logging SECTION 20 Best Practices 270...
Page 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Page 277: ...Appendix B Frequently Asked Questions 276...
Page 296: ...Appendix B Frequently Asked Questions 295...
Page 297: ...Appendix B Frequently Asked Questions 296...
Page 298: ...Appendix B Frequently Asked Questions 297...
Page 299: ...Appendix B Frequently Asked Questions 298...
Page 333: ...Revision history 332...