Visual Basic Scripting error

[Fritzfrederix]

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&quot.Read

strSQL = "INSERT INTO BHI_baalhoek (linenumber) Values ( " & CStr(lngValue) & ""

Set objConnection = CreateObject("ADODB.Connection&quot

objConnection.ConnectionString = strConnectionString

objConnection.Open

Set objCommand = CreateObject("ADODB.Command&quot

With objCommand

.ActiveConnection = objConnection

.CommandText = strSQL

End With

objCommand.Execute

Set objCommand = Nothing

objConnection.Close

Set objConnection = Nothing

MsgBox ("data Is Verzonden&quot

End Sub


Anyone who knows what I'm doing wrong