hi,

When I excute my stored procedure in Query Analyzer theres an output or Record but when i call from VB there is no output......

VB Code...
cmdSPUsed.ActiveConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Tamps2;Data Source=cuiwk12"
cmdSPUsed.CommandText = "usp_PrnAmort"
cmdSPUsed.CommandType = adCmdStoredProc
cmdSPUsed.Parameters.Append cmdSPUsed.CreateParameter("@LaCode", adVarChar, adParamInput, 10, "1")
Set rstADO = cmdSPUsed.Execute
Do While rstADO.State = adStateClosed
If rstADO.State = adStateOpen Then
Exit Do
End If
Loop


TIA