Does any one know of a way to run a stored procedure using Autoplay ? I have a developer who wants me to create a CD to automatically run a stored procedure on a Microsoft SQL database before copying new asp files to a web site.
Professional Software Development Tools
Results 1 to 5 of 5
Thread: Stored Procedures
-
12-10-2002 #1
- Join Date
- Jul 2002
- Location
- USA
- Posts
- 16
Stored Procedures
-
12-10-2002 #2
- Join Date
- Aug 2002
- Posts
- 9,746
Re: Stored Procedures
Well it's easy enough to call a web script, i.e. an ASP page from AutoPlay and the following link explains how to call a stored procedure via ASP:
http://support.microsoft.com/default...;en-us;q164485
So it's definitely do-able, but there might be an even easier way which one of the Microsoft gurus around here might be able to shine some light on, not sure...
Corey Milner
Creative Director, Indigo Rose Software
-
12-10-2002 #3
- Join Date
- Jan 2000
- Posts
- 2,002
Re: Stored Procedures
You could also write a DLL or EXE that does the work through ADO (write it in VB or VC++) and then call it from your AutoPlay application.
-
12-10-2002 #4
- Join Date
- Jul 2002
- Location
- USA
- Posts
- 16
Re: Stored Procedures
What if I have script they want to run like you would you in query analyzer, is there away to run that.
By the way thanks for all the info so far.
-
12-10-2002 #5
- Join Date
- Aug 2002
- Posts
- 9,746
Re: Stored Procedures
Again, via ASP I see no reason why not. If you can do it with ASP then you can do it with AutoPlay... ADO I know nothing about but it sounds like it might also do that...
Corey Milner
Creative Director, Indigo Rose Software
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts