Siemens SIMATIC OpenPCS 7, Руководство по эксплуатации функций

Страница: 82 / 96

The administrator of the databases can take suitable measures to protect the databases from
unauthorized access via Microsoft OLE DB.
Note
With Microsoft OLE DB, only access to WinCC user archives has been tested and released,
but not access to message and process value archives. Use the WinCC OLE DB Provider to
access message and process value archives.
Additional information
● Detailed information on "Security settings when accessing SQL databases via MS OLE
DB" is available in the system manual
MDM - WinCC/Connectivity Pack.
6.7.3 Establishing the connection to the database
ConnectionString
The connection between the application, which reads data via the OLE DB, and the archive
database, is established via the Connection object with ActiveX Data Objects (ADO). One of
the important parameters here is the ConnectionString. The ConnectionString contains all
information necessary for access to the database using the OLE DB provider.
Structure of the ConnectionString
"Provider = name of the OLE DB provider; Catalog=database name;
Data Source=Package name + "\WinCC";"
The "Package name" is made up of the symbolic computer name and "::" e.g.
"OSPro_1_Prj_OS::".
OpenPCS 7 interface
6.7 OLE DB
OpenPCS 7
82
Function Manual, 05/2012, A5E02780178-02