how to call sql server store procedure in classic asp

Question

I have sql srver store procedure which accept 10 parameters as input. How to call this store procedure in classic asp and pass a parameter values to it in classic asp?

Hanook · Answer

Sample code to call a stored procedure in ASP Simple steps to call stored procedure in ASP set con = Server.CreateObject("ADODB.Connection") con.Open strConnect Set Comm = Server.CreateObject("ADODB.Command") comm.ActiveConnection = con comm.CommandText = " sqlstoredprocedure name" comm.CommandType = adCmdStoredProc comm.Parameters.Append comm.CreateParameter("ID" , adVarchar,adParamInput, 50, id) comm.Parameters.Append comm.CreateParameter("PRODUCT", adVarchar, adParamInput,50, producttype ) comm.Parameters.Append comm.CreateParameter("ACCOUNT", adVarchar, adParamInput,100, "" ) comm.Parameters.Append comm.CreateParameter("O_Errors", adVarchar, adParamOutput,50) 'output parameters comm.Execute References: http://stackoverflow.com/questions/15092616/sql-server-stored-procedure-for-asp-classic

Jaganathan Bantheswaran · Answer

Please make the reply as Answer if it helped you.

Jaganathan Bantheswaran · Answer

Hi. Example is here. Set cn = Server.CreateObject("ADODB.Connection") cn.Open "data source name", "userid", "password" Set cmd = Server.CreateObject("ADODB.Command") Set cmd.ActiveConnection = cn ' Define the stored procedure's inputs and outputs ' Question marks act as placeholders for each parameter for the ' stored procedure cmd.CommandText = "{?=call sp_test(?)}" ' specify parameter info 1 by 1 in the order of the question marks ' specified when we defined the stored procedure cmd.Parameters.Append cmd.CreateParameter("RetVal", adInteger, _ adParamReturnValue) cmd.Parameters.Append cmd.CreateParameter("Param1", adInteger, _ adParamInput) cmd.Parameters("Param1") = 33 cmd.Execute %> Calling via method 3 ReturnValue = Source: MSDN

how to call sql server store procedure in classic asp

Answers (3)