Omron CX-Supervisor, Руководство пользователя

Страница: 185 / 334

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.