How to call sql stored procedure in asp

[jennypretty]

Hello,

I created a stored procedure in sql server and it worked when I called from sql QA (exec sp_name)

When I applied this to asp as:

sql = select * from tbl_student
where student_id in (exec dbo.sp_name)

It generated syntax error.

How do I call a stored procedure in asp? Or what is another way to make it work?

Thanks.

[huffmysack]

Make sure your SPROC's are created correctly and that they can be executed correctly. They should execute as caller.

and for the asp side of things:
How to call SQL Server stored procedures from ASP

have fun!

[jennypretty]

good tips.
thanks for that link.

[vikramgavli]

set con = Server.CreateObject("ADODB.Connection")
con.Open strConnect
Set Comm = Server.CreateObject("ADODB.Command")
comm.ActiveConnection = con
comm.CommandText = "SP_NAME"
comm.CommandType = adCmdStoredProc
comm.Execute

<snip/>