![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-v2-0/cx-supervisor-v2-0_user-manual_744213222.webp)
OMRON
CHAPTER 12 – Databases
Release 2.0
Page 199
♦
Click on 'Add' to create a new Data Source Name file
.
This will invoke the Create New Data
Source dialog box with a list of available drivers (only drivers that are installed on your machine
will be shown).
♦
Choose the driver to access the data source and select ‘Next >’.
♦
You will then be prompted to name your Data Source
.
Type a suitable name and select ‘Next >’
♦
Verify the information shown and select 'Finish' to complete this part of the operation.
♦
Depending on the driver selected, you may be prompted for details of the database you wish to
connect to.
♦
A new DSN file will now exist which can be used by CX-Supervisor to Create a Connection.
Creating a Read/Write connection to an Excel file
Connections to Excel files may result in the error “Operation must use an updateable query”. This is
because the Provider installed with ADO version 2.0 is read only by default hence Records can not be
added or amended. To override this function you must manually change the Read Only property in
the Connection String. On the “Modify Connection” dialog click “Advanced…” and set the
connection property as shown in the last line below:
Driver={Microsoft Excel Driver (*.xls)};
DBQ=C:\WorkBook.xls;
ReadOnly=False;
Excel files can also be updated by accessing the file via the ODBC DSN driver
.
This is achieved by
carrying out the following steps:
♦
Create a File DSN for the required Excel file with the following options (see Chapter 12,
Creating a Data Source Name file)
♦
Select the Microsoft Excel Driver (*.xls)
.
If this option does not exist, you will need to install
the Microsoft ODBC driver for Excel from the Excel setup.
♦
Ensure that the "Read Only" check box is clear.
♦
Load the Excel spreadsheet and create a table to access the data by creating a Named Range as
follows:
♦
Highlight the row(s) and column(s) area where your data resides (including the header row).
♦
On the ‘Insert’ menu, point to ‘Name’, click ‘Define’ and enter a name for your range.
♦
Create a connection in the CX-Supervisor Workspace specifying the File DSN as its source.
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...