not enough storage is avaliable to complete this operation

I get this error when transfering data from oracle database over web
service.
there is about 390 rows which is returned from web service like dataset and
it
works ok for about 200 rows. then I get this error.

Can anyone help??

thans!

Since we have no idea what kind of data you're transferring, and therefore
no idea on a row size, all we can do is guess. So I'm guessing that you
have enough memory available for 200 rows, but not for 390. The fix would
be to transfer less rows.


--
Chris Tacke
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--




"BJ" <bernard@hi.hinet.hr> wrote in message
news:ee3qah$18i$1@magcargo.vodatel.hr...
>I get this error when transfering data from oracle database over web
>service.
> there is about 390 rows which is returned from web service like dataset
> and it
> works ok for about 200 rows. then I get this error.
>
> Can anyone help??
>
> thans!
>

hm, but my transfer is ok....that means that i have all the records in one
dataset when starting to insert
that records in database on pocket pc.

so, i think that problem is not in transfer from oracle to dataset in pocket
pc....but in inserting these
records into sql server mobile database on pocket pc.


"<ctacke/>" <ctacke[@]opennetcf[dot]com> wrote in message
news:efoauDb1GHA.3372@TK2MSFTNGP04.phx.gbl...
> Since we have no idea what kind of data you're transferring, and therefore
> no idea on a row size, all we can do is guess. So I'm guessing that you
> have enough memory available for 200 rows, but not for 390. The fix would
> be to transfer less rows.
>
>
> --
> Chris Tacke
> OpenNETCF Consulting
> Managed Code in the Embedded World
> www.opennetcf.com
> --
>
>
>
>
> "BJ" <bernard@hi.hinet.hr> wrote in message
> news:ee3qah$18i$1@magcargo.vodatel.hr...
>>I get this error when transfering data from oracle database over web
>>service.
>> there is about 390 rows which is returned from web service like dataset
>> and it
>> works ok for about 200 rows. then I get this error.
>>
>> Can anyone help??
>>
>> thans!
>>
>
>

Ok, so you have enough to transfer it, but when you do the insert, it
creates a new row in the database and all indexes. These also take up
space, and at some point there's no more space for a requested insert so
it's failing.

Again, you didn't give much info (like where is the database file stored,
how big is a row item, what have you done to debug, etc.), so this is all
just a guess.


--
Chris Tacke
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--



"BJ" <bernard@hi.hinet.hr> wrote in message
news:ee3t8r$9hl$1@magcargo.vodatel.hr...
> hm, but my transfer is ok....that means that i have all the records in one
> dataset when starting to insert
> that records in database on pocket pc.
>
> so, i think that problem is not in transfer from oracle to dataset in
> pocket pc....but in inserting these
> records into sql server mobile database on pocket pc.
>
>
> "<ctacke/>" <ctacke[@]opennetcf[dot]com> wrote in message
> news:efoauDb1GHA.3372@TK2MSFTNGP04.phx.gbl...
>> Since we have no idea what kind of data you're transferring, and
>> therefore no idea on a row size, all we can do is guess. So I'm guessing
>> that you have enough memory available for 200 rows, but not for 390. The
>> fix would be to transfer less rows.
>>
>>
>> --
>> Chris Tacke
>> OpenNETCF Consulting
>> Managed Code in the Embedded World
>> www.opennetcf.com
>> --
>>
>>
>>
>>
>> "BJ" <bernard@hi.hinet.hr> wrote in message
>> news:ee3qah$18i$1@magcargo.vodatel.hr...
>>>I get this error when transfering data from oracle database over web
>>>service.
>>> there is about 390 rows which is returned from web service like dataset
>>> and it
>>> works ok for about 200 rows. then I get this error.
>>>
>>> Can anyone help??
>>>
>>> thans!
>>>
>>
>>
>
>

yes, that is what's happening when inserting into database on my pocket pc.
the question is: what i have to do to insert these records without failing?

i don't believe that it is not possible to insert 300 rows at once.

thanks!

"<ctacke/>" <ctacke[@]opennetcf[dot]com> wrote in message
news:uTCT8Fc1GHA.4176@TK2MSFTNGP06.phx.gbl...
> Ok, so you have enough to transfer it, but when you do the insert, it
> creates a new row in the database and all indexes. These also take up
> space, and at some point there's no more space for a requested insert so
> it's failing.
>
> Again, you didn't give much info (like where is the database file stored,
> how big is a row item, what have you done to debug, etc.), so this is all
> just a guess.
>
>
> --
> Chris Tacke
> OpenNETCF Consulting
> Managed Code in the Embedded World
> www.opennetcf.com
> --
>
>
>
> "BJ" <bernard@hi.hinet.hr> wrote in message
> news:ee3t8r$9hl$1@magcargo.vodatel.hr...
>> hm, but my transfer is ok....that means that i have all the records in
>> one dataset when starting to insert
>> that records in database on pocket pc.
>>
>> so, i think that problem is not in transfer from oracle to dataset in
>> pocket pc....but in inserting these
>> records into sql server mobile database on pocket pc.
>>
>>
>> "<ctacke/>" <ctacke[@]opennetcf[dot]com> wrote in message
>> news:efoauDb1GHA.3372@TK2MSFTNGP04.phx.gbl...
>>> Since we have no idea what kind of data you're transferring, and
>>> therefore no idea on a row size, all we can do is guess. So I'm
>>> guessing that you have enough memory available for 200 rows, but not for
>>> 390. The fix would be to transfer less rows.
>>>
>>>
>>> --
>>> Chris Tacke
>>> OpenNETCF Consulting
>>> Managed Code in the Embedded World
>>> www.opennetcf.com
>>> --
>>>
>>>
>>>
>>>
>>> "BJ" <bernard@hi.hinet.hr> wrote in message
>>> news:ee3qah$18i$1@magcargo.vodatel.hr...
>>>>I get this error when transfering data from oracle database over web
>>>>service.
>>>> there is about 390 rows which is returned from web service like dataset
>>>> and it
>>>> works ok for about 200 rows. then I get this error.
>>>>
>>>> Can anyone help??
>>>>
>>>> thans!
>>>>
>>>
>>>
>>
>>
>
>

The whole point is you get the error because you don't have enough room to
store the data you are trying to. I can't see how you don't believe it -
you're seeing the error, so it's obviously happening. Either you're out of
space on the media or our of storage space in RAM or something but you are
not giving us enough information to help you. We need to know how big a row
is, including index information. We need to know where the database is
stored (storage card, ram, etc). We need to know the type of device (WM 5.0
uses storage differently thatn PPS 03). We need to know what you've already
done to debug this.

Give us answers to all of those and then we can help you.


--
Chris Tacke
OpenNETCF Consulting
Managed Code in the Embedded World
www.opennetcf.com
--



"BJ" <bernard@hi.hinet.hr> wrote in message
news:ee5kbc$8g0$1@magcargo.vodatel.hr...
> yes, that is what's happening when inserting into database on my pocket
> pc.
> the question is: what i have to do to insert these records without
> failing?
>
> i don't believe that it is not possible to insert 300 rows at once.
>
> thanks!
>
> "<ctacke/>" <ctacke[@]opennetcf[dot]com> wrote in message
> news:uTCT8Fc1GHA.4176@TK2MSFTNGP06.phx.gbl...
>> Ok, so you have enough to transfer it, but when you do the insert, it
>> creates a new row in the database and all indexes. These also take up
>> space, and at some point there's no more space for a requested insert so
>> it's failing.
>>
>> Again, you didn't give much info (like where is the database file stored,
>> how big is a row item, what have you done to debug, etc.), so this is all
>> just a guess.
>>
>>
>> --
>> Chris Tacke
>> OpenNETCF Consulting
>> Managed Code in the Embedded World
>> www.opennetcf.com
>> --
>>
>>
>>
>> "BJ" <bernard@hi.hinet.hr> wrote in message
>> news:ee3t8r$9hl$1@magcargo.vodatel.hr...
>>> hm, but my transfer is ok....that means that i have all the records in
>>> one dataset when starting to insert
>>> that records in database on pocket pc.
>>>
>>> so, i think that problem is not in transfer from oracle to dataset in
>>> pocket pc....but in inserting these
>>> records into sql server mobile database on pocket pc.
>>>
>>>
>>> "<ctacke/>" <ctacke[@]opennetcf[dot]com> wrote in message
>>> news:efoauDb1GHA.3372@TK2MSFTNGP04.phx.gbl...
>>>> Since we have no idea what kind of data you're transferring, and
>>>> therefore no idea on a row size, all we can do is guess. So I'm
>>>> guessing that you have enough memory available for 200 rows, but not
>>>> for 390. The fix would be to transfer less rows.
>>>>
>>>>
>>>> --
>>>> Chris Tacke
>>>> OpenNETCF Consulting
>>>> Managed Code in the Embedded World
>>>> www.opennetcf.com
>>>> --
>>>>
>>>>
>>>>
>>>>
>>>> "BJ" <bernard@hi.hinet.hr> wrote in message
>>>> news:ee3qah$18i$1@magcargo.vodatel.hr...
>>>>>I get this error when transfering data from oracle database over web
>>>>>service.
>>>>> there is about 390 rows which is returned from web service like
>>>>> dataset and it
>>>>> works ok for about 200 rows. then I get this error.
>>>>>
>>>>> Can anyone help??
>>>>>
>>>>> thans!
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>