Accessing Web Service from VBA (Type MisMatch)

A

Ayoa

I am attempting to call a web service from Access 2003 (using the built-in
web services reference tool). The web service should return an array of
integers.

Example web method (C#)

[WebMethod]
public int[] GetIntArray()
{
int[] a = new int[5];
for (int i = 0; i < 5; i++)
a = i * 10;
return a;
}

However at the client side (Access VBA) I am getting the Type Mismatch
error.
This is the function (auto-generated by the web services reference tool ) in
VBA that gives the error.

Public Function wsm_GetIntArray() As Variant
'Error Trap
On Error GoTo wsm_GetIntArrayTrap

wsm_GetIntArray = sc_GuidelinesService.GetIntArray()

Exit Function
wsm_GetIntArrayTrap:
GuidelinesServiceErrorHandler "wsm_GetIntArray"
End Function

When i call my web method from a c# client, it works Ok.

Any suggestion how how to fix this is welcome?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,581
Members
45,056
Latest member
GlycogenSupporthealth

Latest Threads

Top