• Home
 · 
• Active Server Pages
 · 
• How to call a stored procedure from active server pages

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

• 1
• 2
• 3
• 4
• 5

(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