![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-v2-0/cx-supervisor-v2-0_user-manual_744213219.webp)
CHAPTER 12 – Databases
OMRON
Page 196
Release 2.0
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’.
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):
Database Connection String dialog
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 shown below, when ‘Advanced’ is pressed on the
Add/Modify Database Connection dialog.
Summary of Contents for CX-SUPERVISOR - V2.0
Page 2: ...CX Supervisor User Manual Software Release 2 0...
Page 3: ......
Page 5: ...CX Supervisor User Manual OMRON Page ii Revision 2 0...
Page 7: ...CX Supervisor User Manual OMRON Page iv Revision 2 0...
Page 11: ...CX Supervisor User Manual OMRON Page viii Revision 2 0...
Page 13: ...CX Supervisor User Manual OMRON Page x Revision 2 0...
Page 15: ...CX Supervisor User Manual OMRON Page xii Revision 2 0...
Page 17: ...CX Supervisor User Manual OMRON Page xiv Revision 2 0...
Page 19: ...CX Supervisor User Manual OMRON Page xvi Revision 2 0...
Page 21: ...CX Supervisor User Manual OMRON Page xviii Revision 2 0...
Page 23: ......
Page 67: ......
Page 97: ......
Page 137: ...CHAPTER 7 Graphics Library OMRON Page 114 Release 2 0...
Page 183: ...CHAPTER 9 Animation OMRON Page 160 Release 2 0...
Page 215: ......
Page 263: ......
Page 269: ......
Page 274: ...OMRON CHAPTER 16 Connecting to Omron Industrial Components Release 2 0 Page 251...
Page 275: ......
Page 285: ......
Page 319: ......
Page 331: ......
Page 351: ......
Page 359: ...GLOSSARY OF TERMS CX Supervisor User Manual OMRON Page 336 Release 2 0...