Example: Stored Procedure Called From ASP

Set cn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Command")

strConn = "driver={SQL Server};server=Pentium;uid=sa; pwd=pagefault;database=Books"
cn.Open strConn
Set cmd.ActiveConnection = cn

cmd.CommandType = adCmdStoredProc
cmd.CommandText = "sp_my_query"

cmd.Parameters.Append cmd.CreateParameter ("@p1",adVarChar, adParamInput, 255, "William Shakespeare")
Set rs = cmd.Execute