![background image](http://html1.mh-extra.com/html/omron/cx-supervisor/cx-supervisor_user-manual_744211185.webp)
Configuring a Connection
SECTION 12 Databases
184
If your data source is not supported, or you have your own drivers for a
particular database, the 'Connection String' can be modified using this dialog
box (consult your database documentation for the required connection string).
12-2-4-1 User Id and Passwords
If a connection to a database requires a user id or password, this can be
supplied by means of the connection string, which can be modified via the
Advanced Dialog as follows:
If you make a mistake while editing the 'connection string', the original string
can be restored by selecting the 'Build Connection String' button. A new
connection string will also be built automatically each time a change of Data
Source is made.
12-2-4-2 Example Connection Strings
Listed below are some example connections strings for the listed providers:
12-2-4-3 Data providers installed with ADO V2.0
Jet
"Provider=Microsoft.Jet.OLEDB.3.5.1; Data
Source=c:\dbname.mdb"
SQL Server
"Provider=SQLOLEDB; Data Source=server_name; Initial
Catalog=dbname; User Id=user_id; Password=user_password"
Index Server "Provider=MSIDXS; Data Source=catalog_name"
DSN
"DSN=data_source_name"
FILEDSN
"FILEDSN=filename.dsn"
MSDASQL
"Driver={Microsoft Excel Driver (*.xls)};
DBQ=c:\Database\Invdb.xls"
Type
Provider Name
Description
Jet 3.51
Microsoft.Jet.OLE
DB.3.51
For Microsoft Access databases
Directory
Services
ADSDSOObject
For resource data stored, such as Active
Directory, this will become more important
when NT5.0 is available.
Содержание 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...