Fritz_frederix
Member
Hello,
I'm working on a project with a WinCC 6.0 application which communicates on one side with a S7-300 and on the other side with a SQL Sever 2000.
The WinCC PLC communication works perfectly but I have some problems with the communication towards the SQL Server.
I'm trying to send some tekst (example G1 or H2 ect) from WinCC towards the SQL Server, I use in WinCC the datatype String (CStr) and I use the datatype Char 16 in the SQL Server.
I'm using Visual Basic Scripting. Each time I would like to send this data I recieve this error message of my VBS debugger
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'G3' is not permitted in this context. Only constants,expressions, or variables allowed here. Column names are not premitted
This is the VBS I wrote
Sub OnLButtonDown(Byval Item, Byval Flags, Byval x, Byval y)
Dim objConnection
Dim strConnectionString
Dim lngValue
Dim strSQL
Dim objCommand
strConnectionString = "Provider=MSDASQL;DSN=CLaSS_Production;UID=sa;PWD=siemens;database=CLaSS"
lngValue = HMIRuntime.Tags("Linenumber").Read
strSQL = "INSERT IGNORE INTO BHI_baalhoek (linenumber) Values ( " & CStr(lngValue) & ");"
Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnectionString
objConnection.Open
Set objCommand = CreateObject("ADODB.Command")
With objCommand
.ActiveConnection = objConnection
.CommandText = strSQL
End With
objCommand.Execute
Set objCommand = Nothing
objConnection.Close
Set objConnection = Nothing
MsgBox ("data Is Verzonden")
End Sub
Anyone who knows what I'm doing wrong
I'm working on a project with a WinCC 6.0 application which communicates on one side with a S7-300 and on the other side with a SQL Sever 2000.
The WinCC PLC communication works perfectly but I have some problems with the communication towards the SQL Server.
I'm trying to send some tekst (example G1 or H2 ect) from WinCC towards the SQL Server, I use in WinCC the datatype String (CStr) and I use the datatype Char 16 in the SQL Server.
I'm using Visual Basic Scripting. Each time I would like to send this data I recieve this error message of my VBS debugger
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'G3' is not permitted in this context. Only constants,expressions, or variables allowed here. Column names are not premitted
This is the VBS I wrote
Sub OnLButtonDown(Byval Item, Byval Flags, Byval x, Byval y)
Dim objConnection
Dim strConnectionString
Dim lngValue
Dim strSQL
Dim objCommand
strConnectionString = "Provider=MSDASQL;DSN=CLaSS_Production;UID=sa;PWD=siemens;database=CLaSS"
lngValue = HMIRuntime.Tags("Linenumber").Read
strSQL = "INSERT IGNORE INTO BHI_baalhoek (linenumber) Values ( " & CStr(lngValue) & ");"
Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = strConnectionString
objConnection.Open
Set objCommand = CreateObject("ADODB.Command")
With objCommand
.ActiveConnection = objConnection
.CommandText = strSQL
End With
objCommand.Execute
Set objCommand = Nothing
objConnection.Close
Set objConnection = Nothing
MsgBox ("data Is Verzonden")
End Sub
Anyone who knows what I'm doing wrong