Calling Reporting Services Web Service from MS Access?

[Edgar]

Hi,

I have been struggeling with this issue for ququite some time, and I hope
you can help me out. My question is how to call the Reporting Services Web
Service from MS Access?

I tried the soap toolkit, but that runs into an error when generating the
classes.

Is there another way to call the RS web service from Access?

Thanks a lot for your help.

 

[Peter Huang [MSFT]]

Hi

Based on my knowledge, Access did not provide intrinsic method to access
Web Service.
If you are using Soap tool kit, can you show your steps and code for us to
have a test.

Also you said that you have problem when genereate class.
But it seems that we can call the web service directly.
Similar with below,

Dim soapClient3
set soapclient3 = CreateObject("MSSOAP.SoapClient30")
On Error Resume Next
Call SoapClient3.mssoapinit("DocSample1.wsdl", "DocSample1",
"Sample1SoapPort") if err <> 0 then
wscript.echo "initialization failed " + err.description end if

Also I think you may try Microsoft Office 2003 Web Services Toolkit.
What's New in the Microsoft Office 2003 Web Services Toolkit
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_2003_ta
/html/ODC_landWST2003_ta.asp

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Edgar]

Hi,

thanks for your quick response.

I found this solution too, but that has a big drawback, it is using late
binding, so it doesn't show the properties and methods in development time.
You need to have a proxy class for that, which exposes the same properties
and methods as the web service, which makes it easier to develop.

I was looking for other options:
- Fix for the Office Soap Toolkit, which returns an error during the
creation of classes in Access when trying to use the Reporting services web
service.
- A COM dll which acts as a proxy class for RS web service.

Hope you have any other suggestions

Thanks,

 

[Peter Huang [MSFT]]

Hi,

Currently I am researching the issue and we will reply here with more
information as soon as possible.
If you have any more concerns on it, please feel free to post here.

Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter Huang [MSFT]]

Hi

Since Office Web Service Toolkit is provided as a "as-is" product, we did
not provide official support for it.
Based on my research, the it seems that there is some type in Reporting
Service WebService can not be handled by Office Web Service Toolkit.
So far as a workaround, I think you may try to use the Late binding
approach as I provide before to see if that works for you.

Also I think if you have no concern, you may try to call the WebService in
.NET which have more support for Web Service according to the MSDN
document,.
Thanks for your understanding!

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.