ASP and Stored procedure

[vsilver]

how do i call stored procedures in ASP using the COM+ model

 

[baddos]

Just like any other command text SQL string. You can also call it via the ADODB.Command object.

 

[Palooka]

You could do it like this, for instance:

Set db = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")

db.Open DSN, USER, PWD
Set rs = db.Execute("sp_myStoredProcedure")

Palooka

 

[palbano]

Or you could look at the FAQ list for the this forum as that subject is discussed in length with sample code.

FAQ == reuse == good == !REDUNDANT == "reduce forum noise"

-pete