March 31, 2011 at 10:51 am
I've got a VB.Net CLR program in VS2008 and i have a web service url that i have added to my web reference folder, but how do i use it within the CLR SP?
Whenever i have used the url before in web service class i use the attributes and declare web method and then extract the data from it into my db, but just not sure if it can work with this type of program?
this is what i have used before..
[WebService(Namespace = "http://prd.sap.smartm.com:8000/sap/bc/srt/wsdl/bndg_4B2B1CA0FFDC1745E1000004160A/wsdl11/allinone/ws_policy/document?sap-client=100")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
public class Service2 : System.Web.Services.WebService
{
[WebMethod]
public com.smartm.sap.smprd.Aufm ZGetMatDocs(string job)
{
.....
March 31, 2011 at 11:19 am
I have not done this with a CLR, but the whole idea is to be able to go outside the realm of SQL Server and create logic and functionality that SQL Server is not natively capable of.
There may some tweaks to make, but I expect that it will work.
Give it a shot and let us know for sure.
March 31, 2011 at 11:23 am
I would love an example of how to do it in clr, i have no idea!
i dont know if a clr can consume a web service url like a web service class can? because how do you declare attributes on the SP method or within it?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply