OMRON
CHAPTER 12 – Databases
Release 2.0
Page 195
Name
For convenience, a unique Connection name is created automatically
.
This can be changed to give a
more meaningful description of the connection, if required.
Data Source
Enter the database file to be used as a Data Source, or locate using the Browse button
.
The following
data source file types are supported:
♦
MS-Access Files (*.mdb)
♦
MS-Excel Files (*.xls)
♦
Text Files (*.txt, *.csv)
♦
FoxPro Files (*.dbf)
♦
Data Source Names (*.dsn)
A Data Source Name file stores information about a database connection in a file
.
See Creating a
Data Source Name file for more information.
Note:
Connecting to CSV or Text files is slightly different from an actual Database
connection
.
Only the ‘Directory’ that contains the required files should be supplied
as a Data Source - if a file is selected, the connection will fail
.
The actual file to be
used is specified later when configuring the Recordset
.
For example, if a collection
of text or csv files are contained in the directory C:\Text then a valid connection
‘Data Source’ is "C:\Text\".
Note:
Connections to CSV or Text files using the Provider installed with ADO version
2.0 are read only. Records can not be added or amended. To create a read/write
connection to a CSV or Text file see chapter 12, Creating a Read/Write connection
to CSV/Text file.
Note:
Connections to Excel files using the Provider installed with ADO version 2.0 are
read only. Records can not be added or amended. To create a read/write connection
to an Excel file see chapter 12, Creating a Read/Write connection to an Excel file.
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.
Advanced
Shows the Connection String dialog, allowing the automatically generated connection string to be
manually edited.
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...