read data from from SQL in WinCC Professional v13

Hello,

I won't set new topic, and I describe my problem here.

I have a problem to read from sql database in WinCC Prof . I've established connection between sql and wincc and  debugger say that conn. Execute strSQL line is wrong. (Error: Incorrect syntax near 'TAG:' ) I tried in this way or in this now comment way with the same result. Have you any suggestion what is wrong? Thank in advance.

Dim strSQLServer, strDatabase
    strSQLServer = HMIRuntime.Tags("@ServerName").Read
   
    If InStr(strSQLServer, "/") Then
        For X = Len(strSQLServer) To 1 Step -1
            If Mid(strSQLServer, X, 1) = "/" Then
                strSQLServer = Left(strSQLServer, X - 1)
                Exit For
            End If
        Next
    End If
   
   
  Dim hilf
  Set hilf = HMIRuntime.Tags("@DatasourceNameRT")
  hilf.Read
  strDatabase = hilf.Value
   
    strConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;" & _
              "Initial Catalog=" & strDatabase & ";" & _
              "Data Source=" & strSQLServer & "\WINCC"

Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnectionString
objConnection.CursorLocation = 3
objConnection.Open
'Attach The Record Set To The Connection
Set oRs = CreateObject("ADODB.Recordset")
Set objCommand = CreateObject("ADODB.Command")
objCommand.CommandType = 1
Set objCommand.ActiveConnection = objConnection

StartDate = "2015-07-07 00:00:00"

EndDate = "2015-07-07 12:00:00"

strSQL = "TAG:R,'arhive_m1\m1_current_t2',"& StartDate & EndDate & ",TimeStep=0,258"

objCommand.CommandText = strSQL
Set oRs = objCommand.Execute

Hello

I have the same problem, I believe it happens because the .net framework understands it as an invalid command.

I have no answer for that and I'm looking for the answer too.

I found a document, about it but this is incomplete.

I put it attached.

I hope it can help, if you find the answer, please share with me.


Regards,

AndreMilke

Hi,

I solved the problem, it was the provider.

Try change it.

Provider=WinCCOLEDBProvider.1;Catalog=CC_SCADA-TA_16_09_12_09_16_07R;Data Source= 10.2.2.243,49206\WINCC

Regards,

AndreMilke