ASP: ------------------------------------------ Set Connect = CreateObject("ADODB.connection") Connect.Open = "PROVIDER=SQLOLEDB; DATA SOURCE=local();database=blabla;USER ID=bla; PASSWORD=blablabla" Connect.Execute("update_status '"& status &"','" & time & "','" & state & "','" & uid & "'") ------------------------------------------
SP: ------------------------------------------ CREATE PROCEDURE [DBO].[update_status](@status nvarchar,@time nvarchar,@state int,@uid nvarchar) AS UPDATE blabla SET status = @status, time=@time, state=@state WHERE uid = @uid; GO ------------------------------------------
Connect.Execute("EXEC update_status '"& status &"','" & time & "','" & state & "','" & uid & "'")
Du mangler en "EXEC", alternativt skulle du fortælle ADO at det er en SP via CommandType
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.