insert image in sql

• enita sw

  Grasshopper

  Points: 10

  More actions

  October 21, 2005 at 12:53 am

  #89700

  i have a problem to insert type image in sql with front end vb 6. this is script :

  Private Sub CmdSave_Click()

      Dim ADOCmd As New ADODB.Command

      Dim ADORs As New ADODB.Recordset

      Set mstream = New ADODB.Stream

     

      With ADOCmd

          .ActiveConnection = sDSN

          .CommandText = "sp_update_photo"         .CommandType = adCmdStoredProc

          .Parameters("@ID_Card") = MIdCard.Text

          mstream.Type = adTypeBinary

          mstream.Open

          mstream.LoadFromFile strFlNm

          .Parameters("@Photo") = mstream.Read

          Set ADORs = .Execute

      End With

      Set ADORs = Nothing

      ADOCmd.ActiveConnection = Nothing

  End Sub

  Run-time error '-2147217833' [Microsoft][ODBC SQL Server Driver]String data, Right Truncation

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  October 22, 2005 at 9:42 am

  #599364

  This is already being addressed here

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**