internal connection error

[Agnes]

I got sql statment "select a,,,,,,z from myTable " (26 fields, 4 fields 's
size is nvarchar(200) )

When the table got over 5000 records and I want to fill in the dataset. It
will show "internal connection error"
IF i only select 400 rows , everything fine .

my aim is fill in the dataset and then export to EXCEL
Please help .

[VJ]

Re: internal connection error

I think you are trying to get the data over a connection that does not
support that much MB, size of data

VJ

"Agnes" <agnes@dynamict ech.com.hkwrote in message
news:eIh9x68aHH A.2552@TK2MSFTN GP06.phx.gbl...

>I got sql statment "select a,,,,,,z from myTable " (26 fields, 4 fields 's
>size is nvarchar(200) )
>
When the table got over 5000 records and I want to fill in the dataset.
It will show "internal connection error"
IF i only select 400 rows , everything fine .
>
my aim is fill in the dataset and then export to EXCEL
Please help .
>
>