Error in VBA module (within Access) trying to consume web services

[Bob Alston]

I get this error

Server was unable to process request. ---> The type initializer for
'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception. --->
Application.Messages.File doesn't exist in the Application Settings.


The process does sent the HTTP GET and receives a response. It then
throws this error.

I cannot find any information on any part of the error message

Suggestions?

 

[Chuck Grimsby]

I get this error

Server was unable to process request. ---> The type initializer for
'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception. --->
Application.Messages.File doesn't exist in the Application Settings.
The process does sent the HTTP GET and receives a response.  It then
throws this error.
I cannot find any information on any part of the error message
Suggestions?

That doesn't sound (or look) like an Access VBA error. To me, it
looks more like an error coming from an external package of some kind.

What *exactly* were you doing when this came up?

 

[Bob Alston]

That doesn't sound (or look) like an Access VBA error.  To me, it
looks more like an error coming from an external package of some kind.

What *exactly* were you doing when this came up?

I agree it is not Access issue.
I was making a call to XML/Soap processing:

Having difficulty using Microsoft web services tookkit in Access 2003
vba. I can use the toolkit just fine to create the classes. My
module code is straightforward:

Sub Main()
'To Use:
'Dimension a variable as new clsws_DownloadService, and then
write code to
'use the methods provided by the class.
'Example:
' Dim ExampleVar as New clsws_DownloadService
' debug.print ExampleVar.wsm_DownloadDocument("Sample Input")
Dim begindate As Date

Dim dwService As New clsws_DownloadService

Dim dwserviceParameter As New struct_DownloadParameter

Dim dwserviceResult As New struct_WSDownloadResult

dwserviceParameter.DownloadType = 1

dwserviceParameter.OrganizationNbr = 3

dwserviceParameter.ParentOrganizationNbr = 2
begindate = #9/1/2009#
dwserviceParameter.FromDate = begindate

dwserviceParameter.ToDate = Date

dwserviceResult = dwService.wsm_DownloadDocument
(dwserviceParameter) <<----- Error occurs while processing this
line
'Debug.Print dwService.wsm_DownloadDocument
(dwserviceParameter)
Console.WriteLine (dwserviceResult.Errors.length)
Stop
End Sub


I fail in

Public Function wsm_DownloadDocument(ByVal obj_Parameter As
struct_DownloadParameter) As struct_WSDownloadResult
'*****************************************************************
'Proxy function created from
http://cmbhstrn.dshs.state.tx.us/cmbhswebservice/service/downloadservice.asmx?WSDL.
'*****************************************************************

'Error Trap
On Error GoTo wsm_DownloadDocumentTrap

Set wsm_DownloadDocument = sc_DownloadService.DownloadDocument
(obj_Parameter) <<<- this line fails

Exit Function
wsm_DownloadDocumentTrap:
Stop
DownloadServiceErrorHandler "wsm_DownloadDocument"
Stop
End Function

The err.description is

Server was unable to process request. ---> The type initializer for
'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception. --->
Application.Messages.File doesn't exist in the Application Settings.


I have tried to look up the message and parts of it via the web and
newsgroups without success.

I am running Vista Ultimate 3 gig memory; Access 2003. I am up to
date of fixes/patches.

I ran Fiddler2 to monitor the activity. I can see an HTTP Get:
GET /cmbhswebservice/service/downloadservice.asmx?WSDL HTTP/
1.1

The response is
HTTP/1.1 200 OK

The text of the response appears to be the text of the WDSL:


<?xml version="1.0" encoding="utf-8"?>

<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://
www.dshs.state.tx.us/cmbhs/" xmlns:s1="http://dshs.cmbhs/
AbstractDomainObject" xmlns:s="http://www.w3.org/2001/XMLSchema"
xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/"
xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
targetNamespace="http://www.dshs.state.tx.us/cmbhs/"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

<wsdl:types>

<s:schema elementFormDefault="qualified" targetNamespace="http://
www.dshs.state.tx.us/cmbhs/">

<s:import namespace="http://dshs.cmbhs/AbstractDomainObject" />

<s:element name="DownloadDocument">

<s:complexType>

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="Parameter"
type="tnsownloadParameter" />

</s:sequence>

</s:complexType>

</s:element>

<s:complexType name="DownloadParameter">

<s:complexContent mixed="false">

<s:extension base="s1:AbstractDomainObject">

<s:sequence>

<s:element minOccurs="1" maxOccurs="1" name="ParentOrganizationNbr"
type="s:int" />

<s:element minOccurs="1" maxOccurs="1" name="OrganizationNbr"
type="s:int" />

<s:element minOccurs="1" maxOccurs="1" name="FromDate"
type="s:dateTime" />

<s:element minOccurs="1" maxOccurs="1" name="ToDate"
type="s:dateTime" />

<s:element minOccurs="1" maxOccurs="1" name="DownloadType"
type="s:short" />

</s:sequence>

</s:extension>

</s:complexContent>

</s:complexType>

<s:element name="DownloadDocumentResponse">

<s:complexType>

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="DownloadDocumentResult"
type="tns:WSDownloadResult" />

</s:sequence>

</s:complexType>

</s:element>

<s:complexType name="WSDownloadResult">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="PrimaryObject">

<s:complexType mixed="true">

<s:sequence>

<s:any />

</s:sequence>

</s:complexType>

</s:element>

<s:element minOccurs="0" maxOccurs="1" name="Errors"
type="tns:ArrayOfServiceError" />

</s:sequence>

</s:complexType>

<s:complexType name="ArrayOfServiceError">

<s:sequence>

<s:element minOccurs="0" maxOccurs="unbounded" name="ServiceError"
nillable="true" type="tns:ServiceError" />

</s:sequence>

</s:complexType>

<s:complexType name="ServiceError">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="Id" type="s:string" />

<s:element minOccurs="0" maxOccurs="1" name="Message" type="s:string" /
</s:sequence>

</s:complexType>

<s:element name="CMBHSAuthenticationHeader"
type="tns:CMBHSAuthenticationHeader" />

<s:complexType name="CMBHSAuthenticationHeader">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="CMBHSUserName"
type="s:string" />

<s:element minOccurs="0" maxOccurs="1" name="CMBHSPassword"
type="s:string" />

</s:sequence>

<s:anyAttribute />

</s:complexType>

</s:schema>

<s:schema elementFormDefault="qualified" targetNamespace="http://
dshs.cmbhs/AbstractDomainObject">

<s:complexType name="AbstractDomainObject" abstract="true" />

</s:schema>

</wsdl:types>

<wsdl:message name="DownloadDocumentSoapIn">

<wsdlart name="parameters" element="tnsownloadDocument" />

</wsdl:message>

<wsdl:message name="DownloadDocumentSoapOut">

<wsdlart name="parameters" element="tnsownloadDocumentResponse" />

</wsdl:message>

<wsdl:message name="DownloadDocumentCMBHSAuthenticationHeader">

<wsdlart name="CMBHSAuthenticationHeader"
element="tns:CMBHSAuthenticationHeader" />

</wsdl:message>

<wsdlortType name="DownloadServiceSoap">

<wsdlperation name="DownloadDocument">

<wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/
wsdl/">Process search client request for match from CMBHS</
wsdl:documentation>

<wsdl:input message="tnsownloadDocumentSoapIn" />

<wsdlutput message="tnsownloadDocumentSoapOut" />

</wsdlperation>

</wsdlortType>

<wsdl:binding name="DownloadServiceSoap"
type="tnsownloadServiceSoap">

<soap:binding transport="http://schemas.xmlsoap.org/soap/http" />

<wsdlperation name="DownloadDocument">

<soapperation soapAction="http://www.dshs.state.tx.us/cmbhs/
DownloadDocument" style="document" />

<wsdl:input>

<soap:body use="literal" />

<soap:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdl:input>

<wsdlutput>

<soap:body use="literal" />

<soap:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdlutput>

</wsdlperation>

</wsdl:binding>

<wsdl:binding name="DownloadServiceSoap12"
type="tnsownloadServiceSoap">

<soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />

<wsdlperation name="DownloadDocument">

<soap12peration soapAction="http://www.dshs.state.tx.us/cmbhs/
DownloadDocument" style="document" />

<wsdl:input>

<soap12:body use="literal" />

<soap12:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdl:input>

<wsdlutput>

<soap12:body use="literal" />

<soap12:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdlutput>

</wsdlperation>

</wsdl:binding>

<wsdl:service name="DownloadService">

<wsdlort name="DownloadServiceSoap"
binding="tnsownloadServiceSoap">

<soap:address location="http://cmbhstrn.dshs.state.tx.us/
cmbhswebservice/service/downloadservice.asmx" />

</wsdlort>

<wsdlort name="DownloadServiceSoap12"
binding="tnsownloadServiceSoap12">

<soap12:address location="http://cmbhstrn.dshs.state.tx.us/
cmbhswebservice/service/downloadservice.asmx" />

</wsdlort>

</wsdl:service>


I do not see a HTTP Post so I do not think the actual request for
information was transmitted.


I also tried this on a Windows XP system with Access 2003 with the
same result.

Any idea what the error message means?

How can I find out more on the error message and how to resolve it.

Thank you

Bob

bobalston9 At yahoo DOT com

 

[Bob Alston]

That doesn't sound (or look) like an Access VBA error. To me, it
looks more like an error coming from an external package of some kind.

What *exactly* were you doing when this came up?

I agree it is apparently not an Access or VBA error. but hopefully
someone else has used Access/vba to consume a web service and may have
encountered this problem.

Having difficulty using Microsoft web services tookkit in Access 2003
vba. I can use the toolkit just fine to create the classes. My module
code is straightforward:

Sub Main()
'To Use:
'Dimension a variable as new clsws_DownloadService, and then
write code to
'use the methods provided by the class.
'Example:
' Dim ExampleVar as New clsws_DownloadService
' debug.print ExampleVar.wsm_DownloadDocument("Sample Input")
Dim begindate As Date

Dim dwService As New clsws_DownloadService

Dim dwserviceParameter As New struct_DownloadParameter

Dim dwserviceResult As New struct_WSDownloadResult

dwserviceParameter.DownloadType = 1

dwserviceParameter.OrganizationNbr = 3

dwserviceParameter.ParentOrganizationNbr = 2
begindate = #9/1/2009#
dwserviceParameter.FromDate = begindate

dwserviceParameter.ToDate = Date

dwserviceResult =
dwService.wsm_DownloadDocument(dwserviceParameter) <<----- Error
occurs while processing this line
'Debug.Print dwService.wsm_DownloadDocument(dwserviceParameter)
Console.WriteLine (dwserviceResult.Errors.length)
Stop
End Sub


I fail in

Public Function wsm_DownloadDocument(ByVal obj_Parameter As
struct_DownloadParameter) As struct_WSDownloadResult
'*****************************************************************
'Proxy function created from
http://cmbhstrn.dshs.state.tx.us/cmbhswebservice/service/downloadservice.asmx?WSDL.
'*****************************************************************

'Error Trap
On Error GoTo wsm_DownloadDocumentTrap

Set wsm_DownloadDocument =
sc_DownloadService.DownloadDocument(obj_Parameter) <<<- this line fails

Exit Function
wsm_DownloadDocumentTrap:
Stop
DownloadServiceErrorHandler "wsm_DownloadDocument"
Stop
End Function

The err.description is

Server was unable to process request. ---> The type initializer for
'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception. --->
Application.Messages.File doesn't exist in the Application Settings.


I have tried to look up the message and parts of it via the web and
newsgroups without success.

I am running Vista Ultimate 3 gig memory; Access 2003. I am up to date
of fixes/patches.

I ran Fiddler2 to monitor the activity. I can see an HTTP Get:
GET /cmbhswebservice/service/downloadservice.asmx?WSDL HTTP/1.1

The response is
HTTP/1.1 200 OK

The text of the response appears to be the text of the WDSL:


<?xml version="1.0" encoding="utf-8"?>

<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/"
xmlns:tns="http://www.dshs.state.tx.us/cmbhs/"
xmlns:s1="http://dshs.cmbhs/AbstractDomainObject"
xmlns:s="http://www.w3.org/2001/XMLSchema"
xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/"
xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
targetNamespace="http://www.dshs.state.tx.us/cmbhs/"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

<wsdl:types>

<s:schema elementFormDefault="qualified"
targetNamespace="http://www.dshs.state.tx.us/cmbhs/">

<s:import namespace="http://dshs.cmbhs/AbstractDomainObject" />

<s:element name="DownloadDocument">

<s:complexType>

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="Parameter"
type="tnsownloadParameter" />

</s:sequence>

</s:complexType>

</s:element>

<s:complexType name="DownloadParameter">

<s:complexContent mixed="false">

<s:extension base="s1:AbstractDomainObject">

<s:sequence>

<s:element minOccurs="1" maxOccurs="1" name="ParentOrganizationNbr"
type="s:int" />

<s:element minOccurs="1" maxOccurs="1" name="OrganizationNbr"
type="s:int" />

<s:element minOccurs="1" maxOccurs="1" name="FromDate" type="s:dateTime" />

<s:element minOccurs="1" maxOccurs="1" name="ToDate" type="s:dateTime" />

<s:element minOccurs="1" maxOccurs="1" name="DownloadType" type="s:short" />

</s:sequence>

</s:extension>

</s:complexContent>

</s:complexType>

<s:element name="DownloadDocumentResponse">

<s:complexType>

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="DownloadDocumentResult"
type="tns:WSDownloadResult" />

</s:sequence>

</s:complexType>

</s:element>

<s:complexType name="WSDownloadResult">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="PrimaryObject">

<s:complexType mixed="true">

<s:sequence>

<s:any />

</s:sequence>

</s:complexType>

</s:element>

<s:element minOccurs="0" maxOccurs="1" name="Errors"
type="tns:ArrayOfServiceError" />

</s:sequence>

</s:complexType>

<s:complexType name="ArrayOfServiceError">

<s:sequence>

<s:element minOccurs="0" maxOccurs="unbounded" name="ServiceError"
nillable="true" type="tns:ServiceError" />

</s:sequence>

</s:complexType>

<s:complexType name="ServiceError">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="Id" type="s:string" />

<s:element minOccurs="0" maxOccurs="1" name="Message" type="s:string" />

</s:sequence>

</s:complexType>

<s:element name="CMBHSAuthenticationHeader"
type="tns:CMBHSAuthenticationHeader" />

<s:complexType name="CMBHSAuthenticationHeader">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="CMBHSUserName"
type="s:string" />

<s:element minOccurs="0" maxOccurs="1" name="CMBHSPassword"
type="s:string" />

</s:sequence>

<s:anyAttribute />

</s:complexType>

</s:schema>

<s:schema elementFormDefault="qualified"
targetNamespace="http://dshs.cmbhs/AbstractDomainObject">

<s:complexType name="AbstractDomainObject" abstract="true" />

</s:schema>

</wsdl:types>

<wsdl:message name="DownloadDocumentSoapIn">

<wsdlart name="parameters" element="tnsownloadDocument" />

</wsdl:message>

<wsdl:message name="DownloadDocumentSoapOut">

<wsdlart name="parameters" element="tnsownloadDocumentResponse" />

</wsdl:message>

<wsdl:message name="DownloadDocumentCMBHSAuthenticationHeader">

<wsdlart name="CMBHSAuthenticationHeader"
element="tns:CMBHSAuthenticationHeader" />

</wsdl:message>

<wsdlortType name="DownloadServiceSoap">

<wsdlperation name="DownloadDocument">

<wsdl:documentation
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Process search client
request for match from CMBHS</wsdl:documentation>

<wsdl:input message="tnsownloadDocumentSoapIn" />

<wsdlutput message="tnsownloadDocumentSoapOut" />

</wsdlperation>

</wsdlortType>

<wsdl:binding name="DownloadServiceSoap" type="tnsownloadServiceSoap">

<soap:binding transport="http://schemas.xmlsoap.org/soap/http" />

<wsdlperation name="DownloadDocument">

<soapperation
soapAction="http://www.dshs.state.tx.us/cmbhs/DownloadDocument"
style="document" />

<wsdl:input>

<soap:body use="literal" />

<soap:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdl:input>

<wsdlutput>

<soap:body use="literal" />

<soap:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdlutput>

</wsdlperation>

</wsdl:binding>

<wsdl:binding name="DownloadServiceSoap12" type="tnsownloadServiceSoap">

<soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />

<wsdlperation name="DownloadDocument">

<soap12peration
soapAction="http://www.dshs.state.tx.us/cmbhs/DownloadDocument"
style="document" />

<wsdl:input>

<soap12:body use="literal" />

<soap12:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdl:input>

<wsdlutput>

<soap12:body use="literal" />

<soap12:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdlutput>

</wsdlperation>

</wsdl:binding>

<wsdl:service name="DownloadService">

<wsdlort name="DownloadServiceSoap" binding="tnsownloadServiceSoap">

<soap:address
location="http://cmbhstrn.dshs.state.tx.us/cmbhswebservice/service/downloadservice.asmx"
/>

</wsdlort>

<wsdlort name="DownloadServiceSoap12" binding="tnsownloadServiceSoap12">

<soap12:address
location="http://cmbhstrn.dshs.state.tx.us/cmbhswebservice/service/downloadservice.asmx"
/>

</wsdlort>

</wsdl:service>


I do not see a HTTP Post so I do not think the actual request for
information was transmitted.


I also tried this on a Windows XP system with Access 2003 with the same
result.

Any idea what the error message means?

How can I find out more on the error message and how to resolve it.

Thank you

Bob

bobalston9 At yahoo DOT com

 

[Chuck Grimsby]

I agree it is apparently not an Access or VBA error.  but hopefully
someone else has used Access/vba to consume a web service and may have
encountered this problem.
Having difficulty using Microsoft web services tookkit in Access 2003
vba.  I can use the toolkit just fine to create the classes.  My module
code is straightforward:

         Sub Main()
         'To Use:
         'Dimension a variable as new clsws_DownloadService, and then
write code to
         'use the methods provided by the class.
         'Example:
         ' Dim ExampleVar as New clsws_DownloadService
         ' debug.print ExampleVar.wsm_DownloadDocument("Sample Input")
         Dim begindate As Date
         Dim dwService As New clsws_DownloadService
         Dim dwserviceParameter As New struct_DownloadParameter
         Dim dwserviceResult As New struct_WSDownloadResult
         dwserviceParameter.DownloadType = 1
         dwserviceParameter.OrganizationNbr = 3
         dwserviceParameter.ParentOrganizationNbr = 2
         begindate = #9/1/2009#
         dwserviceParameter.FromDate = begindate
         dwserviceParameter.ToDate = Date
         dwserviceResult =
dwService.wsm_DownloadDocument(dwserviceParameter)    <<----- Error
occurs while processing this line
         'Debug.Print dwService.wsm_DownloadDocument(dwserviceParameter)
         Console.WriteLine (dwserviceResult.Errors.length)
Stop
     End Sub

I fail in

Public Function wsm_DownloadDocument(ByVal obj_Parameter As
struct_DownloadParameter) As struct_WSDownloadResult
     '*****************************************************************
     'Proxy function created fromhttp://cmbhstrn.dshs.state.tx.us/cmbhswebservice/service/downloadserv....
     '*****************************************************************
     'Error Trap
     On Error GoTo wsm_DownloadDocumentTrap
     Set wsm_DownloadDocument =
sc_DownloadService.DownloadDocument(obj_Parameter)   <<<- this line fails
Exit Function
wsm_DownloadDocumentTrap:
Stop
     DownloadServiceErrorHandler "wsm_DownloadDocument"
     Stop
End Function
The err.description is
Server was unable to process request. ---> The type initializer for
'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception. --->
Application.Messages.File doesn't exist in the Application Settings.

I have tried to look up the message and parts of it via the web and
newsgroups without success.

I am running Vista Ultimate 3 gig memory; Access 2003.  I am up to date
of fixes/patches.

I ran Fiddler2 to monitor the activity.  I can see an HTTP Get:
          GET /cmbhswebservice/service/downloadservice.asmx?WSDL HTTP/1.1

The response is
          HTTP/1.1 200 OK
The  text of the response appears to be the text of the WDSL:
<?xml version="1.0" encoding="utf-8"?>
<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"
xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/"
xmlns:tns="http://www.dshs.state.tx.us/cmbhs/"
xmlns:s1="http://dshs.cmbhs/AbstractDomainObject"
xmlns:s="http://www.w3.org/2001/XMLSchema"
xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/"
xmlns:http="http://schemas.xmlsoap.org/wsdl/http/"
targetNamespace="http://www.dshs.state.tx.us/cmbhs/"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

<wsdl:types>
<s:schema elementFormDefault="qualified"
targetNamespace="http://www.dshs.state.tx.us/cmbhs/">
<s:import namespace="http://dshs.cmbhs/AbstractDomainObject" />
<s:element name="DownloadDocument">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="Parameter"
type="tnsownloadParameter" />
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name="DownloadParameter">
<s:complexContent mixed="false">
<s:extension base="s1:AbstractDomainObject">
<s:sequence>
<s:element minOccurs="1" maxOccurs="1" name="ParentOrganizationNbr"
type="s:int" />

<s:element minOccurs="1" maxOccurs="1" name="OrganizationNbr"
type="s:int" />
<s:element minOccurs="1" maxOccurs="1" name="FromDate" type="s:dateTime" />
<s:element minOccurs="1" maxOccurs="1" name="ToDate" type="s:dateTime" />
<s:element minOccurs="1" maxOccurs="1" name="DownloadType" type="s:short" />
</s:sequence>
</s:extension>
</s:complexContent>
</s:complexType>
<s:element name="DownloadDocumentResponse">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="DownloadDocumentResult"
type="tns:WSDownloadResult" />
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name="WSDownloadResult">
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="PrimaryObject">

<s:complexType mixed="true">

<s:sequence>

<s:any />

</s:sequence>

</s:complexType>

</s:element>

<s:element minOccurs="0" maxOccurs="1" name="Errors"
type="tns:ArrayOfServiceError" />

</s:sequence>

</s:complexType>

<s:complexType name="ArrayOfServiceError">

<s:sequence>

<s:element minOccurs="0" maxOccurs="unbounded" name="ServiceError"
nillable="true" type="tns:ServiceError" />

</s:sequence>

</s:complexType>

<s:complexType name="ServiceError">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="Id" type="s:string" />

<s:element minOccurs="0" maxOccurs="1" name="Message" type="s:string" />

</s:sequence>

</s:complexType>

<s:element name="CMBHSAuthenticationHeader"
type="tns:CMBHSAuthenticationHeader" />

<s:complexType name="CMBHSAuthenticationHeader">

<s:sequence>

<s:element minOccurs="0" maxOccurs="1" name="CMBHSUserName"
type="s:string" />

<s:element minOccurs="0" maxOccurs="1" name="CMBHSPassword"
type="s:string" />

</s:sequence>

<s:anyAttribute />

</s:complexType>

</s:schema>

<s:schema elementFormDefault="qualified"
targetNamespace="http://dshs.cmbhs/AbstractDomainObject">

<s:complexType name="AbstractDomainObject" abstract="true" />

</s:schema>

</wsdl:types>

<wsdl:message name="DownloadDocumentSoapIn">

<wsdlart name="parameters" element="tnsownloadDocument" />

</wsdl:message>

<wsdl:message name="DownloadDocumentSoapOut">

<wsdlart name="parameters" element="tnsownloadDocumentResponse" />

</wsdl:message>

<wsdl:message name="DownloadDocumentCMBHSAuthenticationHeader">

<wsdlart name="CMBHSAuthenticationHeader"
element="tns:CMBHSAuthenticationHeader" />

</wsdl:message>

<wsdlortType name="DownloadServiceSoap">

<wsdlperation name="DownloadDocument">

<wsdl:documentation
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Process search client
request for match from CMBHS</wsdl:documentation>

<wsdl:input message="tnsownloadDocumentSoapIn" />

<wsdlutput message="tnsownloadDocumentSoapOut" />

</wsdlperation>

</wsdlortType>

<wsdl:binding name="DownloadServiceSoap" type="tnsownloadServiceSoap">

<soap:binding transport="http://schemas.xmlsoap.org/soap/http" />

<wsdlperation name="DownloadDocument">

<soapperation
soapAction="http://www.dshs.state.tx.us/cmbhs/DownloadDocument"
style="document" />

<wsdl:input>

<soap:body use="literal" />

<soap:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdl:input>

<wsdlutput>

<soap:body use="literal" />

<soap:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdlutput>

</wsdlperation>

</wsdl:binding>

<wsdl:binding name="DownloadServiceSoap12" type="tnsownloadServiceSoap">

<soap12:binding transport="http://schemas.xmlsoap.org/soap/http" />

<wsdlperation name="DownloadDocument">

<soap12peration
soapAction="http://www.dshs.state.tx.us/cmbhs/DownloadDocument"
style="document" />

<wsdl:input>

<soap12:body use="literal" />

<soap12:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdl:input>

<wsdlutput>

<soap12:body use="literal" />

<soap12:header message="tnsownloadDocumentCMBHSAuthenticationHeader"
part="CMBHSAuthenticationHeader" use="literal" />

</wsdlutput>

</wsdlperation>

</wsdl:binding>

<wsdl:service name="DownloadService">

<wsdlort name="DownloadServiceSoap" binding="tnsownloadServiceSoap">

<soap:address
location="http://cmbhstrn.dshs.state.tx.us/cmbhswebservice/service/downloadserv..."/>

</wsdlort>

<wsdlort name="DownloadServiceSoap12" binding="tnsownloadServiceSoap12">

<soap12:address
location="http://cmbhstrn.dshs.state.tx.us/cmbhswebservice/service/downloadserv..."/>

</wsdlort>

</wsdl:service>

I do not see a HTTP Post so I do not think the actual request for
information was transmitted.
I also tried this on a Windows XP system with Access 2003 with the same
result.
Any idea what the error message means?
How can I find out more on the error message and how to resolve it.

I've used Access a number of times to get and parse a web page, but I
can't say as I've ever used that methodology, so I'm sorry to say that
I can't help. I just get the "raw" web page from doing a "GET" and
parse it that way. The result is sort of like doing a "View Source".
It doesn't come out all nicely formatted, but it works nice and
quickly.

 

[James A. Fortune]

I get this error

Server was unable to process request. ---> The type initializer for
'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception. --->
Application.Messages.File doesn't exist in the Application Settings.

The process does sent the HTTP GET and receives a response. It then
throws this error.

I cannot find any information on any part of the error message

Suggestions?

I think that one of the PDC 05 presentations had a demo that used
Access to consume Web Services. I'm guessing that it was one of the
presentations of the Windows Communication Foundation (prefixed with
COM). I don't remember exactly which presentation it was.

Perhaps:

http://msdn.microsoft.com/en-us/vbasic/cc308389.aspx

or

http://community.visual-basic.it/alessandroenglish/articles/24492.aspx

will help.

James A. Fortune
(e-mail address removed)