As a follow-up, I can also hit the web service with an HTTP GET request: http://www.domain.com/webservices/webservice.asmx/AddUser?ID=#ID#
Is there a straightforward way of doing this in an SP? Cameron > Hi, all. > > I'm trying to hit a remote web service from within a SQL stored > procedure. I don't need any data back; it's just a call to initiate > another process. > > If I were doing this in CF, it would be: > > <cfinvoke webservice="http://www.domain.com/webservices/webservice. > asmx" method="AddUser" ID="#ID# /> > > > Is there a way to do this from within a stored procedure? I've seen > some examples using sp_OACreate and sp_OAMethod, but it seems overkill > for what I'm trying to accomplish. And, I'm having a hard time > deconstructing the MSDN documentation. > > Thanks for the help/tips/info/other. > > Cameron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3223 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
