Consuming Web Services from MS Sql Server

3
Hi guys, so I have quick question with regards to Modeler 3.0.0. I have created an endpoint in SQL server to expose a procedure. Basic stuff with integrated security. Then I tried to import the service using Modeler and got the 401 error. Now I went through some of the old questions raised like a year ago by some other guys and saw that no authentication is enabled in Modeler 2.5. My question is, is authentication enabled or working in Modeler 3.0.0 and if not has anybody came up with a solution?? I kinda found one myself, if you specify basic authentication and Ports to use SSL then it is possible to specify credentials in the URL of the service. But I have not been able to test this so I don't know. and the IETF standards document just describes using base64 encoding for the username and password with the realm and schema specified in plain text or something like that. So please can you guys assist me with this issue. The biggest problem for me is that I can actually use this web service in VS2010 but I myself don't want to use that as my development tool. I want to use Mendix. So if anybody can assist it will be much appreciated. DETAILS FROM MODELER: System.Net.WebException: There was an error downloading 'http://localhost/SQLSERVER/ABSADATA?wsdl'. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. --- End of inner exception stack trace --- at System.Web.Services.Discovery.DiscoveryClientProtocol.Download(String& url, String& contentType) at System.Web.Services.Discovery.DiscoveryClientProtocol.DiscoverAny(String url) at Mendix.Modeler.WebServices.WsdlDescription.ResolveImports(String url) in c:\cygwin\home\autobuild\build\Mendix-3.0\modeler\Modeler\WebServices\Call\WsdlDescription.cs:line 236 at Mendix.Modeler.WebServices.WsdlDescription.BuildContents(String url, List1 messages) in c:\cygwin\home\autobuild\build\Mendix-3.0\modeler\Modeler\WebServices\Call\WsdlDescription.cs:line 69 at Mendix.Modeler.WebServices.WsdlDescription.FromUrl(String url, List1 messages) in c:\cygwin\home\autobuild\build\Mendix-3.0\modeler\Modeler\WebServices\Call\WsdlDescription.cs:line 47 at Mendix.Modeler.WebServices.ImportedServiceEditor.<>cDisplayClass2.<tryimportwsdl>b0() in c:\cygwin\home\autobuild\build\Mendix-3.0\modeler\Modeler\WebServices\Call\ImportedServiceEditor.cs:line 84 at Mendix.Modeler.Utility.Progress.ProgressUtil.<>cDisplayClass4`1.<do>b3(ProgressInfo info) in c:\cygwin\home\autobuild\build\Mendix-3.0\modeler\Mendix.Modeler.Utility.Gui\Progress\ProgressUtil.cs:line 25 at Mendix.Modeler.Utility.Progress.Step.Run(ProgressInfo info) in c:\cygwin\home\autobuild\build\Mendix-3.0\modeler\Mendix.Modeler.Utility.Gui\Progress\Step.cs:line 22 at Mendix.Modeler.Utility.Progress.Process.worker_DoWork(Object sender, DoWorkEventArgs e) in c:\cygwin\home\autobuild\build\Mendix-3.0\modeler\Mendix.Modeler.Utility.Gui\Progress\Process.cs:line 86 at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) WHAT IS RETURNED FROM SERVICE -<wsdl:definitions targetnamespace="http://tempuri.org" xmlns:tns="http://tempuri.org" xmlns:s0="http://tempuri.org" xmlns:sqloptions="http://schemas.microsoft.com/sqlserver/2004/SOAP/Options" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">-<wsdl:types>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes" xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">-<xsd:annotation><xsd:documentation xml:lang="en"> XML Schema describing the base types to which SQL Server types are being mapped. For more information, please consult the documentation. (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation> -<xsd:simpletype name="sqlDbTypeEnum">-<xsd:restriction base="xsd:string"><xsd:enumeration value="BigInt"/><xsd:enumeration value="Binary"/><xsd:enumeration value="Bit"/><xsd:enumeration value="Char"/><xsd:enumeration value="DateTime"/><xsd:enumeration value="Decimal"/><xsd:enumeration value="Float"/><xsd:enumeration value="Image"/><xsd:enumeration value="Int"/><xsd:enumeration value="Money"/><xsd:enumeration value="NChar"/><xsd:enumeration value="NText"/> <xsd:enumeration value="NVarChar"/><xsd:enumeration value="Real"/><xsd:enumeration value="SmallDateTime"/><xsd:enumeration value="SmallInt"/><xsd:enumeration value="SmallMoney"/><xsd:enumeration value="Structured"/><xsd:enumeration value="Text"/><xsd:enumeration value="Timestamp"/><xsd:enumeration value="TinyInt"/><xsd:enumeration value="Udt"/><xsd:enumeration value="UniqueIdentifier"/><xsd:enumeration value="VarBinary"/><xsd:enumeration value="VarChar"/><xsd:enumeration value="Variant"/><xsd:enumeration value="Xml"/></xsd:restriction></xsd:simpletype>-<xsd:simpletype name="sqlCompareOptionsEnum">-<xsd:restriction base="xsd:string"><xsd:enumeration value="Default"/><xsd:enumeration value="None"/><xsd:enumeration value="IgnoreCase"/><xsd:enumeration value="IgnoreNonSpace"/><xsd:enumeration value="IgnoreKanaType"/><xsd:enumeration value="IgnoreWidth"/><xsd:enumeration value="BinarySort"/><xsd:enumeration value="BinarySort2"/></xsd:restriction></xsd:simpletype>-<xsd:simpletype name="sqlCompareOptionsList"><xsd:list itemtype="sqltypes:sqlCompareOptionsEnum"/></xsd:simpletype><xsd:attribute name="sqlDbType" type="sqltypes:sqlDbTypeEnum" default="NVarChar"/><xsd:attribute name="clrTypeName" type="xsd:string"/><xsd:attribute name="maxLength" type="xsd:long" default="1"/><xsd:attribute name="localeId" type="xsd:int" default="-1"/><xsd:attribute name="sqlCompareOptions" type="sqltypes:sqlCompareOptionsList" default="Default"/><xsd:attribute name="sqlCollationVersion" type="xsd:int" default="0"/><xsd:attribute name="sqlSortId" type="xsd:int" default="0"/><xsd:attribute name="scale" type="xsd:unsignedByte" default="0"/><xsd:attribute name="precision" type="xsd:unsignedByte" default="18"/><xsd:attribute name="xmlSchemaCollection" type="xsd:string"/><xsd:attribute name="sqlTypeAlias" type="xsd:string"/> -<xsd:simpletype name="char"><xsd:restriction base="xsd:string"/></xsd:simpletype>-<xsd:simpletype name="nchar"><xsd:restriction base="xsd:string"/></xsd:simpletype>-<xsd:simpletype name="varchar"><xsd:restriction base="xsd:string"/></xsd:simpletype>-<xsd:simpletype name="nvarchar"><xsd:restriction base="xsd:string"/></xsd:simpletype>-<xsd:simpletype name="text"><xsd:restriction base="xsd:string"/></xsd:simpletype>-<xsd:simpletype name="ntext"><xsd:restriction base="xsd:string"/></xsd:simpletype>-<xsd:simpletype name="varbinary"><xsd:restriction base="xsd:base64Binary"/></xsd:simpletype>-<xsd:simpletype name="binary"><xsd:restriction base="xsd:base64Binary"/></xsd:simpletype>-<xsd:simpletype name="image"><xsd:restriction base="xsd:base64Binary"/></xsd:simpletype>-<xsd:simpletype name="timestamp">-<xsd:restriction base="xsd:base64Binary"><xsd:maxlength value="8"/></xsd:restriction></xsd:simpletype>-<xsd:simpletype name="timestampNumeric"> <xsd:restriction base="xsd:long"/></xsd:simpletype>-<xsd:simpletype name="decimal"><xsd:restriction base="xsd:decimal"/></xsd:simpletype>-<xsd:simpletype name="numeric"><xsd:restriction base="xsd:decimal"/></xsd:simpletype>-<xsd:simpletype name="bigint"><xsd:restriction base="xsd:long"/></xsd:simpletype>-<xsd:simpletype name="int"><xsd:restriction base="xsd:int"/></xsd:simpletype>-<xsd:simpletype name="smallint"><xsd:restriction base="xsd:short"/></xsd:simpletype>-<xsd:simpletype name="tinyint"><xsd:restriction base="xsd:unsignedByte"/></xsd:simpletype>-<xsd:simpletype name="bit"><xsd:restriction base="xsd:boolean"/></xsd:simpletype>-<xsd:simpletype name="float"><xsd:restriction base="xsd:double"/></xsd:simpletype>-<xsd:simpletype name="real"><xsd:restriction base="xsd:float"/></xsd:simpletype>-<xsd:simpletype name="datetime">-<xsd:restriction base="xsd:dateTime"><xsd:pattern value="((000[1-9])|(00[1-9][0-9])|(0[1-9][0-9]{2})|([1-9][0-9]{3}))-((0[1-9])|(1[012]))-((0[1-9])|([12][0-9])|(3[01]))T(([01][0-9])|(2[0-3]))(:[0-5][0-9]){2}(\.[0-9]{2}[037])?"/><xsd:maxinclusive value="9999-12-31T23:59:59.997"/><xsd:mininclusive value="1753-01-01T00:00:00.000"/></xsd:restriction></xsd:simpletype>-<xsd:simpletype name="smalldatetime">-<xsd:restriction base="xsd:dateTime"><xsd:pattern value="((000[1-9])|(00[1-9][0-9])|(0[1-9][0-9]{2})|([1-9][0-9]{3}))-((0[1-9])|(1[012]))-((0[1-9])|([12][0-9])|(3[01]))T(([01][0-9])|(2[0-3]))(:[0-5][0-9])(:00)"/><xsd:maxinclusive value="2079-06-06T23:59:00"/><xsd:mininclusive value="1900-01-01T00:00:00"/></xsd:restriction></xsd:simpletype>-<xsd:simpletype name="money">-<xsd:restriction base="xsd:decimal"><xsd:totaldigits value="19"/><xsd:fractiondigits value="4"/><xsd:maxinclusive value="922337203685477.5807"/><xsd:mininclusive value="-922337203685477.5808"/></xsd:restriction></xsd:simpletype>-<xsd:simpletype name="smallmoney">-<xsd:restriction base="xsd:decimal"><xsd:totaldigits value="10"/><xsd:fractiondigits value="4"/><xsd:maxinclusive value="214748.3647"/><xsd:mininclusive value="-214748.3648"/></xsd:restriction></xsd:simpletype>-<xsd:simpletype name="uniqueidentifier">-<xsd:restriction base="xsd:string"><xsd:pattern value="([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12})|(\{[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}\})"/></xsd:restriction></xsd:simpletype> -<xsd:complextype name="xml" mixed="true">-<xsd:sequence><xsd:any processcontents="skip" maxoccurs="unbounded" minoccurs="0"/></xsd:sequence></xsd:complextype> -<xsd:simpletype name="dbobject"><xsd:restriction base="xsd:anyURI"/></xsd:simpletype></xsd:schema>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified">-<xsd:annotation><xsd:documentation xml:lang="en"> (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation>-<xsd:complextype name="SqlRowSet">-<xsd:sequence maxoccurs="unbounded"><xsd:element ref="xsd:schema"/><xsd:any/></xsd:sequence></xsd:complextype>-<xsd:complextype name="SqlXml" mixed="true">-<xsd:sequence><xsd:any processcontents="skip"/></xsd:sequence></xsd:complextype>-<xsd:simpletype name="SqlResultCode">-<xsd:restriction base="xsd:int"><xsd:mininclusive value="0"/></xsd:restriction></xsd:simpletype><xsd:attribute name="IsDataSetWithSchema" type="xsd:boolean"/></xsd:schema>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified">-<xsd:annotation><xsd:documentation xml:lang="en"> (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation>-<xsd:complextype name="SqlTransaction">-<xsd:sequence maxoccurs="1" minoccurs="1"><xsd:element name="Descriptor" type="xsd:base64Binary"/>-<xsd:element name="Type">-<xsd:simpletype>-<xsd:restriction base="xsd:string"><xsd:enumeration value="Begin"/><xsd:enumeration value="Commit"/><xsd:enumeration value="Rollback"/><xsd:enumeration value="EnlistDTC"/><xsd:enumeration value="Defect"/></xsd:restriction></xsd:simpletype></xsd:element></xsd:sequence></xsd:complextype></xsd:schema>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified">-<xsd:annotation><xsd:documentation xml:lang="en"> (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation>-<xsd:complextype name="SqlRowCount">-<xsd:sequence maxoccurs="1" minoccurs="1"><xsd:element name="Count" type="xsd:long"/></xsd:sequence></xsd:complextype></xsd:schema>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified" xmlns:sqlmessage="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage">-<xsd:annotation><xsd:documentation xml:lang="en"> (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation>-<xsd:simpletype name="nonNegativeInteger">-<xsd:restriction base="xsd:int"><xsd:mininclusive value="0"/></xsd:restriction></xsd:simpletype>-<xsd:complextype name="SqlMessage">-<xsd:sequence maxoccurs="1" minoccurs="1"><xsd:element name="Class" type="sqlmessage:nonNegativeInteger"/><xsd:element name="LineNumber" type="sqlmessage:nonNegativeInteger"/><xsd:element name="Message" type="xsd:string"/><xsd:element name="Number" type="sqlmessage:nonNegativeInteger"/><xsd:element name="Procedure" type="xsd:string" minoccurs="0"/><xsd:element name="Server" type="xsd:string" minoccurs="0"/><xsd:element name="Source" type="xsd:string"/><xsd:element name="State" type="sqlmessage:nonNegativeInteger"/></xsd:sequence></xsd:complextype></xsd:schema>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified" xmlns:sqlmessage="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage" xmlns:sqltransaction="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction" xmlns:sqlrowcount="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount" xmlns:sqlsoaptypes="http://schemas.microsoft.com/sqlserver/2004/SOAP/types">-<xsd:annotation><xsd:documentation xml:lang="en"> (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types"/><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage"/><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount"/><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction"/>-<xsd:complextype name="SqlResultStream">-<xsd:choice maxoccurs="unbounded" minoccurs="1"><xsd:element name="SqlRowSet" type="sqlsoaptypes:SqlRowSet"/><xsd:element name="SqlXml" type="sqlsoaptypes:SqlXml"/><xsd:element name="SqlMessage" type="sqlmessage:SqlMessage"/><xsd:element name="SqlRowCount" type="sqlrowcount:SqlRowCount"/><xsd:element name="SqlResultCode" type="sqlsoaptypes:SqlResultCode"/><xsd:element name="SqlTransaction" type="sqltransaction:SqlTransaction"/></xsd:choice></xsd:complextype></xsd:schema>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/Options" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified">-<xsd:annotation><xsd:documentation xml:lang="en"> (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation>-<xsd:element name="initialDatabase">-<xsd:annotation><xsd:documentation>Set initial database on login.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="value" type="xsd:string" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The name of the initial database to attach to.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="optional" type="xsd:boolean" default="false" form="unqualified">-<xsd:annotation><xsd:documentation>Whether the initial database is optional or not.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="filename" type="xsd:string" form="unqualified">-<xsd:annotation><xsd:documentation>The filename of the database to attach to.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="initialLanguage">-<xsd:annotation><xsd:documentation>Set initial language to set.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="value" type="xsd:string" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The name of the initial language to set.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="optional" type="xsd:boolean" default="false" form="unqualified">-<xsd:annotation><xsd:documentation>Whether the initial language is optional or not.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="environmentChangeNotifications">-<xsd:annotation><xsd:documentation>Receive environment change notifications.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="databaseChange" type="xsd:boolean" default="false" form="unqualified">-<xsd:annotation><xsd:documentation>Receive notifications of database changes.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="languageChange" type="xsd:boolean" default="false" form="unqualified">-<xsd:annotation><xsd:documentation>Receive notifications of language changes.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="transactionBoundary" type="xsd:boolean" default="false" form="unqualified">-<xsd:annotation><xsd:documentation>Receive notifications of transaction boundaries.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="applicationName">-<xsd:annotation><xsd:documentation>Set the application name for the login.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="value" type="xsd:string" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The application name to set for the login.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="hostName">-<xsd:annotation><xsd:documentation>Set the host name for the login.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="value" type="xsd:string" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The host name to set for the login.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="clientPID">-<xsd:annotation><xsd:documentation>Set the client process ID for the login.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="value" type="xsd:long" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The client process ID to set for the login.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="clientNetworkID">-<xsd:annotation><xsd:documentation>Set the client network ID for the login.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="value" type="xsd:base64Binary" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The client network ID to set for the login.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="clientInterface">-<xsd:annotation><xsd:documentation>Set the client interface for the login.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="value" type="xsd:string" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The client interface to set for the login.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="notificationRequest">-<xsd:annotation><xsd:documentation>Requests query notifications for the request.</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="notificationId" type="xsd:string" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The notification identifier.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="deliveryService" type="xsd:string" use="required" form="unqualified">-<xsd:annotation><xsd:documentation>The delivery service.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="timeout" type="xsd:integer" form="unqualified">-<xsd:annotation><xsd:documentation>The timeout value.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element>-<xsd:element name="sqlSession">-<xsd:annotation><xsd:documentation>SQL Server SOAP Session</xsd:documentation></xsd:annotation>-<xsd:complextype>-<xsd:attribute name="initiate" type="xsd:boolean" default="false" form="unqualified">-<xsd:annotation><xsd:documentation>Set to 'true' to request to start a new session.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="terminate" type="xsd:boolean" default="false" form="unqualified">-<xsd:annotation><xsd:documentation>Set to 'true' to request to terminate an existing session.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="sessionId" type="xsd:base64Binary" form="unqualified">-<xsd:annotation><xsd:documentation>The ID of a session.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="timeout" type="xsd:int" form="unqualified">-<xsd:annotation><xsd:documentation>The timeout in seconds before the session expires.</xsd:documentation></xsd:annotation></xsd:attribute>-<xsd:attribute name="transactionDescriptor" type="xsd:base64Binary" form="unqualified">-<xsd:annotation><xsd:documentation>The descriptor of a transaction to enlist to.</xsd:documentation></xsd:annotation></xsd:attribute></xsd:complextype></xsd:element></xsd:schema>-<xsd:schema targetnamespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlParameter" xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified" xmlns:sqlparameter="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlParameter">-<xsd:annotation><xsd:documentation xml:lang="en"> (c) Copyright 2004, Microsoft Corporation The following schema for Microsoft SQL Server is presented in XML format and is for informational purposes only. Microsoft Corporation ("Microsoft") may have trademarks, copyrights, or other intellectual property rights covering subject matter in the schema. Microsoft does not make any representation or warranty regarding the schema or any product or item developed based on the schema. The schema is provided to you on an AS IS basis. Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without limiting the generality of the foregoing, Microsoft does not make any warranty of any kind that any item developed based on the schema, or any portion of the schema, will not infringe any copyright, patent, trade secret, or other intellectual property right of any person or entity in any country. It is your responsibility to seek licenses for such intellectual property rights where appropriate. MICROSOFT SHALL NOT BE LIABLE FOR ANY DAMAGES OF ANY KIND ARISING OUT OF OR IN CONNECTION WITH THE USE OF THE SCHEMA, INCLUDING WITHOUT LIMITATION, ANY DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL (INCLUDING ANY LOST PROFITS), PUNITIVE OR SPECIAL DAMAGES, WHETHER OR NOT MICROSOFT HAS BEEN ADVISED OF SUCH DAMAGES. </xsd:documentation></xsd:annotation><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes"/>-<xsd:simpletype name="ParameterDirection">-<xsd:restriction base="xsd:string"><xsd:enumeration value="Input"/><xsd:enumeration value="InputOutput"/></xsd:restriction></xsd:simpletype>-<xsd:complextype name="ArrayOfSqlParameter">-<xsd:sequence><xsd:element name="SqlParameter" type="sqlparameter:SqlParameter" maxoccurs="unbounded" minoccurs="0"/></xsd:sequence></xsd:complextype>-<xsd:complextype name="SqlParameter">-<xsd:sequence><xsd:element name="Value" maxoccurs="1" minoccurs="1" nillable="true"/></xsd:sequence><xsd:attribute name="name" type="xsd:string" use="required" form="unqualified"/><xsd:attribute name="sqlDbType" type="sqltypes:sqlDbTypeEnum" default="NVarChar" use="optional" form="unqualified"/><xsd:attribute name="direction" type="sqlparameter:ParameterDirection" default="Input" use="optional" form="unqualified"/><xsd:attribute name="maxLength" type="xsd:long" default="1" use="optional" form="unqualified"/><xsd:attribute name="precision" type="xsd:unsignedByte" default="18" use="optional" form="unqualified"/><xsd:attribute name="scale" type="xsd:unsignedByte" default="0" use="optional" form="unqualified"/><xsd:attribute name="clrTypeName" type="xsd:string" default="" use="optional" form="unqualified"/><xsd:attribute name="typeName" type="xsd:string" default="" use="optional" form="unqualified"/><xsd:attribute name="sqlCompareOptions" type="sqltypes:sqlCompareOptionsList" default="Default" use="optional" form="unqualified"/><xsd:attribute name="localeId" type="xsd:int" default="-1" use="optional" form="unqualified"/><xsd:attribute name="sqlCollationVersion" type="xsd:int" default="0" use="optional" form="unqualified"/><xsd:attribute name="sqlSortId" type="xsd:int" default="0" use="optional" form="unqualified"/><xsd:attribute name="xmlSchemaCollection" type="xsd:string" default="" use="optional" form="unqualified"/></xsd:complextype></xsd:schema>-<xsd:schema targetnamespace="http://tempuri.org" xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes" attributeformdefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified" xmlns:sqlmessage="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage" xmlns:sqlrowcount="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount" xmlns:sqlsoaptypes="http://schemas.microsoft.com/sqlserver/2004/SOAP/types" xmlns:sqlparameter="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlParameter" xmlns:sqlresultstream="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream"><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes"/><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream"/>-<xsd:element name="ABSALIST">-<xsd:complextype><xsd:sequence/></xsd:complextype></xsd:element>-<xsd:element name="ABSALISTResponse">-<xsd:complextype>-<xsd:sequence><xsd:element name="ABSALISTResult" type="sqlresultstream:SqlResultStream" maxoccurs="1" minoccurs="1" nillable="false"/></xsd:sequence></xsd:complextype></xsd:element></xsd:schema></wsdl:types>-<wsdl:message name="s0MsgABSALISTSoapIn"><wsdl:part name="parameters" element="s0:ABSALIST"/></wsdl:message>-<wsdl:message name="s0MsgABSALISTSoapOut"><wsdl:part name="parameters" element="s0:ABSALISTResponse"/></wsdl:message>-<wsdl:porttype name="ABSA_DATA_ENDPOINTSoap">-<wsdl:operation name="ABSALIST"><wsdl:input name="s0MsgABSALISTSoapIn" message="tns:s0MsgABSALISTSoapIn"/><wsdl:output name="s0MsgABSALISTSoapOut" message="tns:s0MsgABSALISTSoapOut"/></wsdl:operation></wsdl:porttype>-<wsdl:binding name="ABSA_DATA_ENDPOINTSoap" type="tns:ABSA_DATA_ENDPOINTSoap"><soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>-<wsdl:operation name="ABSALIST"><soap:operation style="document" soapaction="http://tempuri.orgABSALIST"/>-<wsdl:input name="s0MsgABSALISTSoapIn"><soap:body use="literal"/></wsdl:input>-<wsdl:output name="s0MsgABSALISTSoapOut"><soap:body use="literal"/></wsdl:output></wsdl:operation></wsdl:binding>-<wsdl:service name="ABSA_DATA_ENDPOINT">-<wsdl:port name="ABSA_DATA_ENDPOINT" binding="tns:ABSA_DATA_ENDPOINTSoap"><soap:address location="http://localhost/SQLSERVER/ABSADATA"/></wsdl:port></wsdl:service></wsdl:definitions>
asked
2 answers
2

I had a similar problem a while back. https://forum.mendix.com/questions/751/SQL%20Server%20Web%20Service.

answered
0

I am facing the same.

A direct call to the webservice does not work.

When saving the WSDL separately and importing the file a schema error pops up

answered