General information
Category:
Database DAO/RDO/ODBC/ADO
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only