Re: Trying to call to stored proc from ASP?

Hi Adrian,

If you are not passing any parameters to the stored procedure, you could just use:

sSQL = "sp_stored_procedure_name"

Hope this helps
Mark

"_adrian" <test @ test.com> wrote in message news:%234hlIorcGHA.1260@xxxxxxxxxxxxxxxxxxxxxxx
Hey all.. I've written a stored proc to execute a particular DTS package, and that all works. What I'm trying to do now is trigger that process from an ASP page... the following code *should* work I think.. and if so, then what else might be keeping me from success???? HELP!
(The driver login criteria has been changed to protect the innocent)

<%
dim dataConn, sSql, rs
set dataConn = Server.CreateObject("ADODB.Connection")
dataConn.Open "Driver={SQL Server};Server=hostservername;Database=DB;Uid=test;Pwd=test;"
sSql = "{call SendDirectory}"
Set rs = dataConn.Execute(sSql) 'execute sql call
%>


.

Loading