I know you can run dll statements and perform sql queries with vb script, is it possible to run a stored procedure on SQL 2000 also? If so, how? Billy Ballard
Set cnx = Server.CreateObject("ADODB.Connection"
cnx.Open DSN '<-- your connection string value here
cnx.execute "exec {your stored procedure}" '<--- this bit matters...
cnx.Close: Set cnx = Nothing
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.