Siemens SIMATIC OpenPCS 7 User Manual

Parameter Description
Provider Name of the OLE DB provider: e.g. WinCCOLEDBProvider
Catalog The "CC_ExternalBrowsing" database can also be used.
Note
For transparent access, enter the name of the PCS 7 OS project for "Catalog", for
example: "Catalog=WinCC_Project_Name".
Note
If you access message archives or swapped archives with "CC_ExternalBrowsing",
access can take several minutes.
Data
Source
For transparent access to the central archive server or with redundant servers using the
OLE DB provider, enter the following for "Data Source": <Symbolic computer name>::
\WinCC.
Note
If you access an archive tag in the long-term server "CAS", use the name of the archive
tag. The long-term archive server "CAS" returns the CAS-ID as the ID and not the ID of
the archive tag:
<Symbolic computer name>\\<Archive_Var_Name>
Example of a VBA application:
In the following example, a connection object is generated and then the connection to the
WinCCdatabase (process value or message archive) is opened.
Dim sPro As String
Dim sDsn As String
Dim sSer As String
Dim sCon As String
sPro = "Provider=WinCCOLEDBProvider.1;"'Provider
SDsn = "Catalog=CC_OS_06_09_25_13_36_53;"'Catalog
SSer = "Data Source=OSPro_1_Prj_OS::\WinCC"'Data Source
SCon = sPro + SDsn + SSer 'Connection String
'Connection
Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = SCon
conn.CursorLocation = 3
conn.Open
6.7.4 Access to the OLE DB provider
Access options
With OLE DB, you have the following options to access PCS 7 OS archive data:
● Access with the WinCC OLE DB provider
● Access with Microsoft OLE DB
OpenPCS 7 interface
6.7 OLE DB
OpenPCS 7
Function Manual, 05/2012, A5E02780178-02 83

Siemens SIMATIC OpenPCS 7 Specifications

General

Brand	Siemens
Model	SIMATIC OpenPCS 7
Category	Control Systems
Language	English