Hello,

I try to put an image into a sql db, and i think i am close but now i still get the message

[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@FORM_SCAN".
How can i declare this variable? When i try to do this in sql db it tells me
The text, ntext, and image data types are invalid for local variables.
How can i solve this?

Code:
Dim mStream As New ADODB.Stream
        With mStream
            .Type = adTypeBinary
            .Open
            .LoadFromFile TheData.ImageFiles.ReleasedDirectory
        End With
   
        Dim MyParameter As ADODB.Parameter
               
        'Set MyParameter = cmd.CreateParameter("rows", adInteger, adParamOutput)
        Set MyParameter = cmd.CreateParameter("@FORM_SCAN", adLongVarBinary, adParamInput, mStream.Size)
        cmd.Parameters.Append MyParameter
        cmd.ActiveConnection = cnn
        cmd.CommandText = "INSERT INTO deelnemer_aanw_scan VALUES (" & sbatchID & ", @FORM_SCAN)"
        cmd.Parameters(0).Value = mStream.Read
        cmd.Execute