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  adVarcharadParamInput 50 id) comm.Parameters.Append comm.CreateParameter(PRODUCT adVarchar adParamInput50 producttype ) comm.Parameters.Append comm.CreateParameter(ACCOUNT adVarchar adParamInput100  ) comm.Parameters.Append comm.CreateParameter(O_Errors adVarchar adParamOutput50) '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