September 12, 2002 at 4:35 pm
is there a way i can call an asp page from a stored proc?
September 12, 2002 at 6:57 pm
You could probably launch a browser pointed to it, either using xp_cmdshell or sp_oacreate. Dont see how you could easily get back results from it. What are you trying to accomplish?
Andy
September 13, 2002 at 4:51 am
What do you need to get from the page? There are various ways you could accomplish thru various means, some of which depend on your SQL server version.
Example, I want to hit a remote site, submit specific data and get a return set.
I do this daily with VB app to do paging using the browser control. Basically I have a query table (which is to send data), every 5 secounds this table is checked and the data is submitted and when the result page returns I look for the phrase sent page then store the datetime this occurred.
Now I have also seen a com dll and saw the code somewhere to read an asp page when returned without using the browser control. WHich code be easily fixed to be an xp process or used with the sp_oacreate procedure to retrieve the page content.
All boils down to what you need.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply