SOAP/Native XML Web Services

Apr 3, 2008

Anyone have experience with using SOAP/Native XML Web Services in SQL Server 2005 to expose data to external web clients? Any issues/pitfalls?

-A

View 2 Replies


ADVERTISEMENT

Reporting Services With Out SOAP

Aug 31, 2007

Is it possible to render a report with out usieng the SOAP API. I need to use a WCF web service instead of the ASMX web service that is made availible in SSRS. I would like to be able to to create a WCF that calls reporting services via a class library and not the web service interface.

Thanks for help

Jon

View 9 Replies View Related

Reporting Services :: Server Did Not Recognize Value Of HTTP Header SOAP Action

Jun 29, 2015

I have just upgraded from Report server 2005 to 2008 r2. I have a program that calls the report server to run some reports but I have getting the error Server did not recognize the value of http header SOAPAction:

[URL] .....

I can log in to the report server and run any report that I want without any issues.

View 3 Replies View Related

Reporting Services :: Get Report Toolbar Using SOAP API In SSRS Reporting?

Nov 3, 2015

Is there any way to get the report toolbar using SOAP Api  in SSRS reporting.

View 6 Replies View Related

SQL Server 2005's Native Web Services

Mar 23, 2006

Are SQL Server 2005's native Web services available in SQL Server 2005 Express Edition?
Thanks.

View 8 Replies View Related

SQL Server Admin 2014 :: Installation With Reporting Services - Native Errors

Jul 19, 2015

When I try to install sql server 2014 on my machine,all the features were installed but except Reporting services-Native and error occurred as shown below.

Error details:
§ Error installing SQL Server Reporting Services
Updating permission setting for folder 'C:WindowsTemp' failed. The folder permission setting were supposed to be set to 'DA;OICI;0x1200af;;;S-1-5-80-4063824523-3130906261-2263067808-2545249320-213050741)'.
Error code: 0x84CF0003

View 8 Replies View Related

Integration Services :: Using 2008 Native Client 10.0 Provider To Connect 2012 DB?

Jul 9, 2015

In our packages, we are using Microsoft SQL Server Native Client 10.0 provider to connect our SQL Server 2008 DBs, which is working fine till we are migrating 2008 DB server to 2012. after the upgrade, some of our packages are working fine, some are not. I'm just curiuos to know will the
old provider(Microsoft SQL Server Native Client 10.0) will work fine for connecting 2012 DBs? or I need to update all our packages to re-point to new 2012 Provider.

View 5 Replies View Related

Reporting Services :: Can't Find Any Literature On The Native Mode SSRS Databases

Jun 15, 2015

I can't find any literature on the native mode SSRS databases.

so something similar to the MSDB sys tables [URL] Is documentation non existent?

View 2 Replies View Related

Reporting Services :: Create Dashboard With SSRS 2008 R2 Native Mode?

Jul 22, 2015

We want to create interactive dashboards using SSRS 2008 R2. We currently has Report Server installed in Native mode. I see that we can build some good dashboards using SSRS, SharePoint 2010 and PerformancePoint. But I wanted to find out if we can build that level of dashboard using just SSRS. We are still convincing the management for getting SharePoint license. In case if they don't agree for the Sharepoint license, can we build some good dashboards just using SSRS?

View 5 Replies View Related

DTS And SOAP Web Service

Feb 3, 2007

Hi,I have a client that needs to issue soap calls to a third-party webservice from within a DTS package. Is this even possible? I'velooked everywhere and found the sqlxml, but that looks like itprovides a soap web service, not consumes one.Right now, we are consuming the same web service in an ASP.NETapplication and would love to use the same code, but am really justlooking for the best solution. Basically, the only firm requirementsare that the client needs to provide a text file of items that need tobe posted to the third-party via their web service. Right now, we usedts for the client to upload other text files, that's why I was hopingto use the same procedure, but if we need to go another route, I'msure I can convince them.Any suggestions?Trey

View 1 Replies View Related

Troubleshooting SOAP

Jul 20, 2005

Hi,This is the first time I use SOAP. Dont really know the exact pictureyet. Hope you can shed some lights on me.May I know where should I start troubleshooting if I get the followinerror message when running SOAP on Windows 2003, SQL Server 2000 ?Error Code: 0 Error Source= Microsoft VBScript runtime error ErrorDescription: ActiveX component can't create object:'MSSOAP.SOAPClient' Error on Line 1. The step failed.Thanks.

View 2 Replies View Related

Possible SOAP Version Mismatch

Feb 6, 2007

Getting this error after installing certificate. Happens when trying to access https://machinename/reports

Possible SOAP version mismatch: Envelope namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting http://schemas.xmlsoap.org/soap/envelope/. SQL Server Reporting Services 2005 on Windows Server 2003 R2.

Was working fine before adding the certificate.

Any thougts on how to fix?

Thanks in advance,

Dan

View 1 Replies View Related

How To Read Soap File

May 8, 2007

Hi all,



I am sending request to the third party server EX:"Http://somesight.sight.net/company.asp?AC="1000"&Item="200"&DT=05/08/2007" I am getting file in soap format


<?xml version="1.0" encoding="UTF-8" standalone="no" ?>

- <SOAP-ENV:Envelope xmlnsOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">


- <SOAP-ENV:Body>


- <mtreamIResponse xmlns:m="uri:EXmsg">


<Success>false</Success>
</mtreamImageResponse>

- <SOAP-ENV:Fault>


<faultcode>SOAP-ENV:Error</faultcode>

<faultstring>No matching items were found.</faultstring>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

My question is how to read this line <faultstring>No matching items were found.</faultstring> . I need to capture the message in the variable.

Thanks for your help in advance





View 1 Replies View Related

SQL Soap Endpoint Header

May 14, 2007

I created my SOAP endpoint in SQL 2005 sp 2, I worte an ASP.NET 2.0 app to consume the exposed webmethod but how do you add the soap headers in the asp.net app?
Basically I want to expose the application name property to set it to determine the actual caller in SQL Profiler. Can it be done without modifying the generated proxy code in ASP.net or is there a workaround ?

Thanks
J

View 4 Replies View Related

How To Pass In SOAP Header For XML Datasource

Apr 3, 2006

Hi,



I have created a simple webservice with a soap header and am trying to
access it using an xml datasource in reporting services. The query
works but I have no idea how to pass in a value for the UID on the host
header. Any help? what XML would I add for the header?



This is what I have no that allows me to pass in parameters through the editor.

<Query>

<Method Namespace="http://tempuri.org/" Name="HelloPerson2"/>

<SoapAction>http://tempuri.org/HelloPerson2</SoapAction>

</Query>



Here is the code for the webservice:

/// <summary>

/// Summary description for WebService

/// </summary>

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class WebService : System.Web.Services.WebService {



public WebService () {



//Uncomment the following line if using designed components

//InitializeComponent();

}



[Serializable]

public class PersonHeader : SoapHeader

{

private int _uid;

public int UID

{

get { return _uid; }

set { _uid = value; }

}

}



public PersonHeader userCredentials;



[WebMethod]

[SoapHeader("userCredentials")]

public Person HelloPerson2(string firsName, string lastName)

{

Person person = new Person();

//person.FirstName = "John";

//person.LastName = "Smith";

person.FirstName = firsName;

person.LastName = lastName;

person.UID = userCredentials.UID;

return person;

}



[Serializable]

public class Person

{

public Person()

{

}

private string _firstName;

public string FirstName

{

get { return _firstName; }

set { _firstName = value; }

}

private string _lastName;

public string LastName

{

get { return _lastName; }

set { _lastName = value; }

}

private int _uid=1000;

public int UID

{

get { return _uid; }

set { _uid = value; }

}

}

}

View 7 Replies View Related

ReportViewer Control And SOAP Version

Dec 19, 2006

We have just upgraded from an embedded browser hosted RS2000 system to the Microsoft.ReportViewer.Winforms control for RS2005 in our applications, and have encountered a SOAP / firewall problem again.

We were using an embedded browser to display the reports, as some of our client sites block or strip the SOAP wrapper from SOAP 1.1 commands that the old RS2000 control tried to use when the data passes through their firewall. We have no control over, or visability of their firewall configuration, as this is part of their own site security.

Is RS2005 still using the same older version of SOAP, or has it been moved up to version 1.2, which I believe does not trigger as many alarm bells in some firewall systems.

We have no problems makeing web service calls to our own applications through the firewall, so its only the report viewer control that gives us these problems.

I have not been able to explicitly clarify this down to the SOAP version, but it looks too close the our previous firewall problem to be anything else - comments invited !!!!!

As an aside, is there any way to trace the inbound request through IIS to ReportServer so I can see what hits the report server ? The IIS logs alone show a request has been made, but no qualifying data, and the report server logs only seem to show processing once the request has been accepted. What I want to to is see the inbound request, and then the outbound error message being returned so I can confirm my suspicions.

I have posted a similar thread on google groups for reporting services.





View 1 Replies View Related

SOAP Endpoint Access Using InfoPath &&amp; SPD

Nov 28, 2007

I posted this in the Sharepoint Designer forum, but did'nt get an answer...so trying here...Below is my soap endpoint in sql2005...works fine for InfoPath to consume the service...but when SharePoint Designer attempts to retieve data I get

"The server returned a non-specific error when trying to get data from the data source."

In SPD I can connect to the service and see the methods and parameters...but never get any data returned...wondering if it's in my endpoint setup. BTW-using Windows security by default in SQL2005...I've tried different types of logins without success...

/****** Object: Endpoint [getSCMADataEndpoint] Script Date: 11/28/2007 10:38:43 ******/

CREATE ENDPOINT [getSCMADataEndpoint]

AUTHORIZATION [SCMAadministrator]

STATE=STARTED

AS HTTP (PATH=N'/getscmadatawebservice', PORTS = (CLEAR), AUTHENTICATION = (), SITE=N'scmasvr01', CLEAR_PORT = 80, COMPRESSION=DISABLED)

FOR SOAP (

WEBMETHOD 'GetCourseInfo'( NAME=N'[SCMA].[dbo].[prGetCourseInfo]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseLectures'( NAME=N'[SCMA].[dbo].[prGetCourseLectures]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseLecturesInstr'( NAME=N'[SCMA].[dbo].[prGetCourseLecturesInstr]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseObjectives'( NAME=N'[SCMA].[dbo].[prGetCourseObjectives]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseRosterInfo'( NAME=N'[SCMA].[dbo].[prGetCourseRosterInfo]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetSCMAAccounts'( NAME=N'[SCMA].[dbo].[prLookupSCMA_accounts]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetSCMAAccounts_FieldNames'( NAME=N'[SCMA].[dbo].[prLookupSCMA_Accounts_FieldNames]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'SCMA', NAMESPACE=N'http://tempuri.org', SCHEMA=STANDARD, CHARACTER_SET=XML)

View 4 Replies View Related

Outbound SOAP Notification For DML Events

Jan 11, 2008

I'm using a SQL-2005 DB to manage TFS Build Information. I need to create a SOAP web service call in response to an INSERT in the Builds table.
I am, however, thoroughly confused about the most efficient way to do this. The best I can come up with is to create a CLR function that takes the build number from the DB Insert statement, creates the XML and sends the msg to my already published (and already being used) WebService. The CLR function would be called in a trigger set of by the insert.

I don't suppose there is a native way to generate outbound SOAP msgs based upon DML events?

View 3 Replies View Related

Tracing HTTP/SOAP Endpoints

Mar 23, 2008

Has anyone worked out how to trace SOAP/HTTP Endpoints in SQL 2005 SP 2?

I'm not having a particular problem, just want to know how things work, such as which layer is responsible for the HTTP Authentication. I've traced the HTTP.sys stack using logman.exe (see http://www.thelastpickle.com/2008/03/22/tracing-sql-soap-endpoints-through-httpsys/) .

I cannot see any SQL Profiler events, and I've tried setting trace 7801 and 7803 as described in http://www.sqljunkies.com/Article/5CCAC423-1407-4A36-AF71-ED6A67D9646A.scuk#_Toc52964195 but they do not result in any logging.

thanks
Aaron

View 3 Replies View Related

Webservice And Access To SOAP Envelope

Dec 1, 2005

The web serivce for blogging to Community Server requires the username and password to be specified in the SOAP Header and not the body, I however can't access the soap header. How can I achieve this?

View 1 Replies View Related

Web Service Task And Authentication Using Soap Headers

Jan 17, 2006

I've tried creating several Web Service Tasks and had no problems until I came across one that requires authentication. I have a standalone program to handle this Web Service, but I'm experimenting with SSIS to see if I can replace it.

Anyone know how to handle this?

Thanks
-- Scott

View 2 Replies View Related

Error Opening Pdf Report Called Via SOAP

Oct 9, 2007

We've been opening pdf reports using SOAP for some time now and all of the sudden we're getting errors when the user is on IE6. IE7 is fine.

The error we're getting is from the Acrobat reader is:

"There was an error opening the document. The file cannot be found"

Here's the code that opens the report:


Dim report As Byte() = Nothing

Dim rs As report_engine2.ReportExecutionService = New report_engine2.ReportExecutionService

'credentials

rs.Credentials = New System.Net.NetworkCredential(rs_login, rs_password)

rs.PreAuthenticate = True

Dim reportpath As String = rs_folder & report_name

Dim zoom As String = "False"

Dim deviceInfo As String = Nothing

Select Case format

Case "HTML4.0", "HTML3.2"

deviceInfo = "<DeviceInfo>"

deviceInfo &= "<Toolbar>False</Toolbar>"

deviceInfo &= "<Parameters>False</Parameters>"

deviceInfo &= "<HTMLFragment>True</HTMLFragment>"

deviceInfo &= "<StyleStream>False</StyleStream>"

deviceInfo &= "<Section>0</Section>"

deviceInfo &= "<Zoom>" & zoom & "</Zoom>"

deviceInfo &= "</DeviceInfo>"

Case Else

deviceInfo = "<DeviceInfo></DeviceInfo>"

End Select



'array of parameters

Dim parameters(0) As report_engine2.ParameterValue '0 means one parameter in the report

Dim paramValue As report_engine2.ParameterValue = New report_engine2.ParameterValue

paramValue.Name = param1_name

paramValue.Value = param1_value

parameters(0) = paramValue

'variables for the remaining paramters

Dim historyID As String = Nothing

Dim credentials As report_engine2.DataSourceCredentials = Nothing

Dim showHideToggle As String = Nothing

Dim extension As String = GetExtension(mimeType)

Dim warnings() As report_engine2.Warning = Nothing

Dim reportHistoryParameters() As report_engine2.ParameterValue = Nothing

Dim streamIDS() As String = Nothing

Dim execInfo As New report_engine2.ExecutionInfo

Dim execHeader As New report_engine2.ExecutionHeader

rs.ExecutionHeaderValue = execHeader

execInfo = rs.LoadReport(reportpath, historyID)

rs.SetExecutionParameters(parameters, "en-us")

Try

'execute the report

report = rs.Render(format, deviceInfo, "", mimeType, "", warnings, streamIDS)

'set the filename

Dim fileName As String = savefilename & "." & extension

'write the report back to the response object

response.Clear()

response.ContentType = mimeType

'add the file name to the response if it is not a web browser format.

If mimeType <> "text/html" Then

response.AddHeader("Content-Disposition", "attachment; filename=" & fileName)

End If



'send the byte array containing the report

HttpContext.Current.Response.BinaryWrite(report)

HttpContext.Current.Response.End()

Catch ex As Exception

End Try



This used to work just fine until about a week ago. We're not sure if there was a MS update that caused this behavior. If the user saves the report to a local disk instead of opening it, they can save it successfully and open it later.

Any thoughts on where to go with this one?

Regards

View 1 Replies View Related

Soap Error Sqlserver Does Not Exist Or Access Denied

Sep 16, 2006

Hello All,I have a webservice uses a vb.net component that accesses thrid party dll to connect to a sqlserver dbase, username,dbase name ,server and password are passed to the third party dll for login purpose.This works fine in development evironment when pda client calls webservice, A soap error is thrown to the client "sqlserver does not exist or access denied" when the client calls the deployed webservice. I have tried the following 1. Added ASPNet user to the database 2.Added domian user to the database both has public and dbowner rightsCan any one help??[:'(]Thanks Regards    

View 1 Replies View Related

Soap Message Exchange Between .NET Webservice And Stored Procedure

Aug 16, 2007

Hello,

is message exchange between a .NET Webservice and a SQL stored procedure possible?
And if, could you please explain me how? Or give me a tip where i can get more informations
and maybe samples?
thanks for your help

regards
pamelia

View 30 Replies View Related

SOAP API Rendering In HTML4.0 Format With Toggle Items

Jul 25, 2007

I have been combing the Internet trying to find a way to use the SOAP API
(ReportExecution2005) web service to render a report to HTML4.0 format with
toggle items. From what I have read, the new web services should provide
ASP.NET server-side postbacks from the toggle item images, but so far I have
seen only the same behavior as was in RS 2000, which was that the toggle item
images pointed back to the ReportServer address. The following is the device
info settings that i have used to get the images to show up on the aspx page:

<DeviceInfo><StreamRoot></StreamRoot><Toolbar>False</Toolbar>
<Parameters>False</Parameters>
<HTMLFragment>False</HTMLFragment>
StyleStream>False</StyleStream>
<Section>0</Section>
DeviceInfo>

If I switch the HTMFragment to True I don't get any toggle item images to
render on the page but the report still shows up, and when I actually set the
StreamRoot paramter to something like this
"http://[server]/[virtualdirectory]/GetImage.aspx?reportpath=[path]&streamid=" to render the toggle item images, I get a http 400 : Bad Request error page.

Can someone please provide some information or sample code on how to render
an HTML4.0 report using the SQL 2005 Reporting Services web service and
getting the toggle item images to render as well as work correctly.

Thanks,

Brian

View 3 Replies View Related

SSIS Web Service Task - SOAP Header Input

Feb 7, 2008



Hi,

In SSIS web service task - when you specify the Service and Method in the input tab for a WSDL file being used,
it seems to prompt for the parameters to be supplied only in the body of the WSDL file, and not the header.

I need to be able to provide security information (present in the SOAP header of the WSDL) like username, password etc..which is necessary to post any response to the web server, and I cannot see where I can give this in the input tab of the web service task.

Any help highly appreciated.

Thanks


View 3 Replies View Related

Make Connection To SOAP Endpoint Without Integrated Login?

Feb 10, 2007

I have a endpoint on our SQL Server and I've written a test .Net app to access it and it all works great. It uses the Integrated Login for Authentication.

My project in the end will have connections made to the endpoint via some custom code on a Non Windows/Linux platform. My concern is that there is no Authentication method that I can use from this client. Integrated is out since it not something you log into. SSL is out since there is no Cert store. Isn't there a way to use the SQL Authentication in a Mixed mode SQL Authentication install?

What are my other options? I need to be able to get data from our SQL server from this custom platform. We looked into using TDS protocol, but would rather not have to license it and develop a client on our platform. We wanted to just generate the HTTP Packets to send and receive the data.



Thank you,

Scott<-

View 1 Replies View Related

Help With SOAP Lite Client Error Problems - CGI Code

Mar 13, 2006

Hi,

I have been working on a soap client project for over a week now and can not figure out what I am doing wrong. I am not an expert using Perl or SOAP so any help would be "greatly" appreciated.

I get basic errors throughout, starting with:
Error - SOAP::Transport::HTTP::Client::send_receive: POST
It seems as if the user access information is not carried through as it should, but I truly have no idea what the problem is.

Here is what I have put together so far.

Thanks,
Mark

sub procgetmemberinfo {

my $pin = "$form{'lPin'}";
my $password = "$form{'sPassword'}";

my $soap = SOAP::Lite
-> uri('https://xmlsql.XXXXX.xxx:441')
-> on_action( sub { join '/', 'https://xmlsql.XXXXX.xxx:441', $_[1] } )
-> proxy('https://xmlsql.XXXXX.xxx:441/service.asmx?WSDL');

my @params = (
SOAP::Data->name(lPin => $pin),
SOAP::Data->name(sPassword => $password)
);

my $method = SOAP::Data->name('GetMemberInfo')->attr({xmlns => 'https://xmlsql.XXXXX.xxx:441/'});

my $result = $soap->call($method => @params);
unless ($result->fault) {

my $title = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/TITLE');
my $firstname = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/FIRST');
my $middlename = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/MIDDLE');
my $lastname = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/LAST');
my $suffix = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/SUFFIX');
my $address1 = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/STREET_ADDRESS');
my $address2 = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/ADDRESS2');
my $city = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/CITY');
my $stateprovince = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/STATE_PROV');
my $postalcode = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/ZIP');
my $country = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/COUNTRY');
my $homephone = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/HOME_PHONE');
my $workphone = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/WORK_PHONE');
my $emailaddress = $result->valueof('//GetMemberInfoResult/diffgram/NewDataSet/MEMBERS/EMAIL');

print "<font face=arial size=2><b>PIN Number:</b> $pin</font><br>";
print "<font face=arial size=2><b>Password:</b> $password</font><br>";
print "<font face=arial size=2><b>Title:</b> $title</font><br>";
print "<font face=arial size=2><b>First Name:</b> $firstname</font><br>";
print "<font face=arial size=2><b>Middle Name:</b> $middlename</font><br>";
print "<font face=arial size=2><b>Last Name:</b> $lastname</font><br>";
print "<font face=arial size=2><b>Suffix:</b> $suffix</font><br>";
print "<font face=arial size=2><b>Address1:</b> $address1</font><br>";
print "<font face=arial size=2><b>Address2:</b> $address2</font><br>";
print "<font face=arial size=2><b>City:</b> $city</font><br>";
print "<font face=arial size=2><b>State:</b> $stateprovince</font><br>";
print "<font face=arial size=2><b>ZIP/Postal Code:</b> $postalcode</font><br>";
print "<font face=arial size=2><b>Country:</b> $country</font><br>";
print "<font face=arial size=2><b>Home Phone:</b> $homephone</font><br>";
print "<font face=arial size=2><b>Work Phone:</b> $workphone</font><br>";
print "<font face=arial size=2><b>Email Address:</b> $emailaddress</font>";

}

else {
print join ', ',
$result->faultcode,
$result->faultstring,
$result->faultdetail;
}


}

View 4 Replies View Related

Ensuring SOAP Request Success/Failure Notification

May 2, 2007

More of a general SOAP service call question.



Does anybody have any experience/advice on how to ensure that SOAP service call success/failures are returned to the calling app?



Consider a client that calls a SOAP service during which the client goes down and is unable to receive the SOAP response, the work having been done by the service. Similarly, the SOAP service may perform the task but a failure in the return makes the client think the process failed.



What would be the best way to ensure that the client is notified to avoid the call having to be made again?



Are there middleware tools that can be used to provide a form of message queuing for SOAP service calls?



Thanks



View 1 Replies View Related

SOAP Endpoint: When Using ROWSETS_ONLY Format - Warning In SQL Creates Corrupter Response

Apr 13, 2007

I have noticed that when I created SOAP endpoint and a webmethod uses ROWSETS_ONLY format €“ if a warning is raised in T-SQL implementing webmethod then response is being terminated.
Either nothing is returned, and calling application (build with VS 2005) gets error €œThe underlying connection was closed€?, or part of response is retuned but terminated in the middle, and calling application gets error €œThere is an error in XML document (1, 8001).€?
This can be caused by any warning, in my case it was €œ€¦NULL values eliminate by aggregate€¦€? warning. It will behave same way with errors.
Is there any way to make SQL Server send a proper response in case of warning? Should this be reported as bug to Microsoft?

View 4 Replies View Related

Type TypePoint Is Marked For Native Serialization, But Field X Of Type TypePoint Is Not Valid For Native Serialization

Oct 6, 2006

I made a point type by C# for deploying in SQL2005.

It builds successfully every time.

When I deploy, it gives the following error:
"Error: Type "SqlServerProject1.TypePoint" is marked for native serialization, but field "x" of type "SqlServerProject1.TypePoint" is not valid for native serialization." although x variable is value type decimal.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

[Serializable]
[SqlUserDefinedType(Format.Native, IsByteOrdered=true)]
public struct TypePoint : INullable
{
private bool m_Null;

private Decimal x;
private Decimal y;

public override string ToString()
{
// Replace the following code with your code

if (IsNull) // added part
{
return "null";
}
else
{
return x + ":" + y;
} // end of this part

// return "";
}

public bool IsNull
{
get
{
// Put your code here
return m_Null;
}
}

public static TypePoint Null
{
get
{
TypePoint h = new TypePoint();
h.m_Null = true;
return h;
}
}

public static TypePoint Parse(SqlString s) // Most Important Part
{
if (s.IsNull)
{
return Null;
}
else // added part
{
TypePoint p = new TypePoint();
string str = s.ToString();
string[] xy = str.Split(':');
p.x = Decimal.Parse(xy[0]);
p.y = Decimal.Parse(xy[1]);
return p;
}
}

public Decimal X
{
get
{
return x;
}
set
{
x = value;
}
}

public Decimal Y
{
get
{
return y;
}
set
{
y = value;
}
} // end of added part

// This is a place-holder method
public string Method1()
{
//Insert method code here
return "Hello";
}

// This is a place-holder static method
public static SqlString Method2()
{
//Insert method code here
return new SqlString("Hello");
}

// This is a place-holder field member
public int var1;
}

View 4 Replies View Related

Http Endpoints For SOAP In SQL Server 2005 - Can The Stored Proc Referenced Do More Than Select?

Feb 17, 2008

I am new to web services and as a DBA I only have limited .net experience. Our development team is creating a web services interface for our new IVR phone system, and we've decided on a solution that will send each of the phone call parameters from our database to the phone system in an XML based on line number and extension. I've found that Http Endpoints in sql server will be a perfect solution for exactly that and I won't need any .net to develop it. Thats the good news. There are, however, other requirements for our phone system to communicate back to our database. All of the examples I've seen for endpoints use a stored procedure performing a select statement.

Is it possible to create an endpoint that references a stored procedure performing an insert or update? To be more specific, can I create an endpoint that references a stored procedure that has parameters? If so, how do I pass those parameters through a web service request? Is it as simple as adding &variable="value" to the url?

If so I could develop this entire solution from the database side and not involve our .net programmer!

Another alternative: the phone system does have it own database in sql server. I'm not sure if our phone system provided can or will do this, but if they are willing to work with this, maybe a service broker can fit into this solution.

I look forward to any response. Thanks!

View 5 Replies View Related

Native BCP SQL 7.0 To SQL 6.5

Nov 16, 1999

Is it possible to do a native BCP from 7.0 to 6.5? I'm having all sorts of data issues when I try.

Would a character bcp work (albeit slowly) instead?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved