Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2009-10-13 : 07:27:52
|
| I need to reach out and "touch" a web page from within SQL Server 2008.I have an existing, generic, solution for this that is a stored procedure (XMLHTTP) that uses sp_OACREATE to create and use an MSXML2.ServerXMLHTTP object to do this, accepting the URL as one of the parameters so it can be used for any page that needs touching.This has worked fine since I created it for SQL 2000.We have recently upgraded to SQL 2008 and fighting my way through the surface area configuration and XML versions to get this working again made me wonder if there was a better, more native SQL 2008 way to achieve this?Does anyone have any pointers to how I can achieve this in SQL 2008 or is my current implementation the best way to do this for now? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-10-13 : 07:32:04
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111356
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2009-10-13 : 08:38:34
|
| Thanks, but isn't just swapping my current sp_OACREATE (MSXML2.ServerXMLHTTP) for another (WinHttp.WinHttpRequest.5.1)? Now I have SQL Server 2008 I was trying to see if there was a more sql server / native way of achieving this without mucking about with external object... |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-10-13 : 11:57:20
|
| we have a similar solution for HTTP sms push via MSSQL and have been using it on both 2005 and 2008.EXEC @send = sp_OACreate 'MSXML2.XMLHTTP' |
|
|
|
|
|
|
How to make an HTTP call in SQL Server 2008...