me imagino que ya sabes como crear una dll y compilarla..
bueno ahi va:
CODIGO ASP
Código:
Dim objSP
Dim rs
Set objSP = Server.CreateObject("Dll_sp.Recorset")
Set rs = objSP.Rescatar()
while not rs.eof
response.write rs.fields("campo1")&"<br>"
response.write rs.fields("campo2")
..
..
..
rs.movenext
wend
CODIGO DLL
Código:
Public Function Rescatar() As Recordset
Dim ConnectionString As String
Dim strsql As String
Dim rs As Recordset
ConnectionString="TU_DSN"
Set rs = CreateObject("ADODB.Recordset")
strsql = "exec tu_sp"
rs.Open strsql, ConnectionString, adOpenForwardOnly
Set Rescatar = rs
End Function
lo unico ke falta es ligar tu sp y listo..
;)