Omron CX-SUPERVISOR - V2.0, User Manual

Page: 220 / 370

OMRON CHAPTER 12 – Databases
Release 2.0 Page 197
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 (consult your database documentation for the
required connection string).
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.
Example Connection Strings
Listed below are some example connections strings for the listed providers:
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"