Error retrieve data returned from Web Service

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wing Chan - 07 Oct 2005 20:26 GMT

Hello,

I am having a runtime error when automating the following process:

-Make a connection to a web service that returns a recordset of data (which
is a lot more than 80,000 rows and with lots of columns)
-Then insert all these records into an access table
-Refresh the pivot table in excel that is pointed to that access table.

The error I got is that when that the variable I declared from below
(arrTemp) cannot hold that many rows of records.
Does anyone have some insights I really appreciate it. Thanks in advance.

Set oSOAPClient = CreateObject("MSSOAP.SoapClient")
oSOAPClient.MSSoapInit "http://" + sServer +
"/WebService1/Service1.asmx?wsdl", "Service1", "Service1Soap"

Dim arrTemp()
arrTemp = oSOAPClient.spSlsCrossTab()

Reply to this Message

Registered User - 08 Oct 2005 07:04 GMT

>Hello,
>
[quoted text clipped - 8 lines]
>(arrTemp) cannot hold that many rows of records.
>Does anyone have some insights I really appreciate it. Thanks in advance.

80,000 of anything is a relatively large number. The run-time array
error is a symptom that suggests something is wrong with the server
design. The client would be better served if paged data were
available. Each client could then set its desired page size when
consuming the data

public sometype[] spSlsCrossTab(int StartingRecord, int
RecordsToReturn);

regards
A.G.

> Set oSOAPClient = CreateObject("MSSOAP.SoapClient")
> oSOAPClient.MSSoapInit "http://" + sServer +
>"/WebService1/Service1.asmx?wsdl", "Service1", "Service1Soap"
>
> Dim arrTemp()
> arrTemp = oSOAPClient.spSlsCrossTab()

Reply to this Message

Error retrieve data returned from Web Service

Free Magazines