Configuring a Connection
SECTION 12 Databases
185
The above is just the list of standard providers supplied by Microsoft. Other
vendors are actively creating their own.
12-2-5 Creating a Data Source Name file
A Data Source Name file (or DSN for short) stores information about a
database connection in a file. The file has the extension .DSN and by default is
stored in the "$\Program Files\Common Files\ODBC\Data Sources" directory.
This type of file can be viewed with a suitable text editor e.g. "Notepad". One
advantage of using a DSN file over specifying the full path of the database is
that the DSN file remains unchanged while its contents can be re-configured to
reflect any changes in directory or database file name etc.
12-2-5-1 Creating a New DSN
•
For Windows 98, ME and NT: From your Windows 'Control Panel', select
the ODBC Data Sources icon. This will show the ODBC Data Source
Administrator dialog box. For Windows 2000 and XP: From the 'Programs'
folder, select 'Administrative tools' and 'Data Sources (ODBC) icon (note
this is only available if the logged in user has administrative rights, and the
Taskbar properties "Display Administrative Tools' option is checked). This
will show the ODBC Data Source Administrator dialog box.
•
Click the 'File DSN' tab. Any
Data Source Names
already defined are
listed.
•
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.
Index Server MSIDXS
For Microsoft Index Server.
ODBC
Drivers
MSDASQL
For existing ODBC Drivers, this ensures
that legacy data is not omitted.
Oracle
MSDAORA
Native Oracle driver simplifies access to
existing Oracle data stores.
SQL Server
SQLOLEDB
For Microsoft SQL Server.
Data Shape
MSDataShape
For hierarchical recordsets, this allows the
creation of master/detail type recordsets,
which allow drilling down into detailed data.
Persisted
Records
MSPersist
For locally saved recordsets.
Simple
Provider
MSDAOSP
For creating your own providers for simple
text data.
Type
Provider Name
Description
Содержание 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...