Data Services in Access 2010 (1 Viewer)

Kowalski

Registered User.
Local time
Today, 12:55
Joined
Jul 5, 2007
Messages
121
Hi
In Access 2010 it is now possible to link a web service as a table.
However, when I try to link a Data Service, and select the XML file, I get errors.
I can't find a lot of info on the Interwebs, so I'm not even sure that I've got the correct kind of xml file.

Error I get is
"The Microsoft Access database engine encountered an error while connecting to Data Services: Name cannot begin with the '.' character...Line 1 Position 2".

Extract of XML file below.

Is this even the correct kind of XML the Data Services are looking for?


<definitions name='RTUWSService' targetNamespace='http://ws.dms.barnstone.com/' xmlns='http://schemas.xmlsoap.org/wsdl/' xmlns:soap='http://schemas.xmlsoap.org/wsdl/soap/' xmlns:tns='http://ws.dms.eskom.com/' xmlns:xsd='http://www.w3.org/2001/XMLSchema'>
<types>
<xs:schema targetNamespace='http://ws.dms.barnstone.com/' version='1.0' xmlns:tns='http://ws.dms.barnstone.com/' xmlns:xs='http://www.w3.org/2001/XMLSchema'>
<xs:element name='getControlSuccessRate' type='tns:getControlSuccessRate'/>
<xs:element name='getControlSuccessRateResponse' type='tns:getControlSuccessRateResponse'/>
<xs:element name='getRawDataByDate' type='tns:getRawDataByDate'/>
<xs:element name='getRawDataByDateResponse' type='tns:getRawDataByDateResponse'/>
<xs:complexType name='getRawDataByDate'>
<xs:sequence>
<xs:element minOccurs='0' name='arg0' type='xs:dateTime'/>
<xs:element minOccurs='0' name='arg1' type='xs:dateTime'/>
</xs:sequence>
</xs:complexType>
<xs:complexType name='getRawDataByDateResponse'>
<xs:sequence>
<xs:element maxOccurs='unbounded' minOccurs='0' name='return' type='xs:string'/>
</xs:sequence>
</xs:complexType>
<xs:complexType name='getControlSuccessRate'>
<xs:sequence>
<xs:element minOccurs='0' name='arg0' type='xs:dateTime'/>
<xs:element minOccurs='0' name='arg1' type='xs:dateTime'/>
</xs:sequence>
</xs:complexType>
<xs:complexType name='getControlSuccessRateResponse'>
<xs:sequence>
<xs:element maxOccurs='unbounded' minOccurs='0' name='return' type='xs:string'/>
</xs:sequence>
</xs:complexType>
</xs:schema>
</types>
<message name='RTUWS_getControlSuccessRate'>
<part element='tns:getControlSuccessRate' name='getControlSuccessRate'></part>
</message>

...
...
 

Users who are viewing this thread

Top Bottom