Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stored procedures 2

Status
Not open for further replies.

Delphin

Programmer
Nov 27, 2001
134
US
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

For in the past, Lies the future.
 
Create your database object to do the following:

Set cnx = Server.CreateObject("ADODB.Connection")
cnx.Open DSN '<-- your connection string value here
cnx.execute &quot;exec {your stored procedure}&quot; '<--- this bit matters...
cnx.Close: Set cnx = Nothing


[ponder]KrK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top