How to call a stored procedure from active server pages
How to call a stored procedure from active server pages
Rate How to call a stored procedure from active server pages
(3(3 Vote))
<% option explicit%>
<!-- #include virtual="adovbs.inc"-->
'Open the Connection
set conn = Server.CreateObject("ADODB.Connection")
conn.open "dsn=dsn;uid=username;pwd=password"
'Now call the stored Procedure
Set cmd=Server.CreateObject("ADODB.Command")
set cmd.activeconnection=conn
cmd.commandtext="Procedure_name"
cmd.commandtype=adcmdStoredProc
cmd.parameters.refresh
cmd.parameters(1).value = Value1
cmd.parameters(2).value = Value2
.
.
cmd.parameters(n).value = Valuen
'for the ouput from stored procdure
cmd.execute
returnvalue = cmd.parameters(0).value
' and for resultset
set rs = cmd.execute.
conn.close
How to call a stored procedure from active server pages Comments
No comments yet — be the first to post one!
Post a Comment