SQL stored procedure!
Posted on 2001-06-22
here is a peice of code that is giving an error:
"Optional feature not implemented"
Dim cmd As New ADODB.Command, storedParam(6) As New ADODB.Parameter
cmd.ActiveConnection = dbCon.ConnectionString
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "storedProcName"
storedParam(0).Type = adBSTR
storedParam(0).Size = 10
storedParam(0).Direction = adParamInput
storedParam(0).Value = cust_id
.... ' continues with other parameters, one of them is of date type
' code ends here
on executing the statement
cmd.execute , affectedRecords
i am missing something here and very minor i guess
i have tried to use a different cursor for my dbCon variable and now not using any! still giving problems!