请问如何建立WINCC和ORACLE ,SQL的连接
帮助里的例子是连接ACCESS的,过程如下:
1. Create the Access database with the WINCC_DATA table and columns (ID, TagValue) with the ID as the Auto Value.

2. Set up the ODBC data source with the name "SampleDSN", reference to the above Access database.

3. Programming.

Example 1

'VBS108

Dim objConnection

Dim strConnectionString

Dim lngValue

Dim strSQL

Dim objCommand

strConnectionString = "Provider=MSDASQL;DSN=SampleDSN;UID=;PWD=;"

lngValue = HMIRuntime.Tags("Tag1").Read

strSQL = "INSERT INTO WINCC_DATA (TagValue) VALUES (" & lngValue & ");"

Set objConnection = CreateObject("ADODB.Connection")

objConnection.ConnectionString = strConnectionString

objConnection.Open

Set objCommand = CreateObject("ADODB.Command")

With objCommand

objCommand.ActiveConnection = objConnection

objCommand.CommandText = strSQL

End With

objCommand.Execute

Set objCommand = Nothing

objConnection.Close

Set objConnection = Nothing

换成SQL时连接的参数变为:
"[Provider=provider;]DRIVER=driver; SERVER=server;

DATABASE=database; UID=user; PWD=password"

请问参数如何配置,在编写代码之前应在SQL如何设置,参数如何对应填写

希望斑竹和高手们能给出详细的过程,谢谢