Prev: MMControl
Next: Run-time error '20535'
From: Dib on 11 Sep 2005 16:07
Hi,

I am getting this error in my VB 6 program. The backend is SQL Server 2000.
When using the program processing orders in about after 20 - 30 orders I am
getting this
runtime error -2147206398 (80043b02)Memory full.


I am setting my rs as new ADOBD record but I am closing the rs after every
use.
Nothing else, the event viewer is empty.

Please help.

Dib




From: Dib on 11 Sep 2005 16:13
I am using Crystal Reports 9.0 in my App. The reports some of them contains
images.
Dib

"Dib" <dNOSPAMibs(a)comcast.net> wrote in message
news:OE%23RlxwtFHA.3528(a)TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I am getting this error in my VB 6 program. The backend is SQL Server
> 2000. When using the program processing orders in about after 20 - 30
> orders I am getting this
> runtime error -2147206398 (80043b02)Memory full.
>
>
> I am setting my rs as new ADOBD record but I am closing the rs after every
> use.
> Nothing else, the event viewer is empty.
>
> Please help.
>
> Dib
>
>
>
>


From: jma on 12 Sep 2005 00:54
Dib wrote:

>>I am setting my rs as new ADOBD record but I am closing the rs after every
>>use.
>>Nothing else, the event viewer is empty.


Make sure you free all the memory with Set:

Dim rsRecordset as ADODB.Recordset

Set rs = New ADODB.Recordset
rs.Open ...
<your code here>

rs.Close
Set rs = Nothing


--
jma


From: Dib on 12 Sep 2005 18:00
Thanks for your reply this did not help for I was already doing that.

Thanks
Dib

"jma" <no(a)such.thing> wrote in message
news:43250a0d$0$28915$9b536df3(a)news.fv.fi...
> Dib wrote:
>
> >>I am setting my rs as new ADOBD record but I am closing the rs after
every
> >>use.
> >>Nothing else, the event viewer is empty.
>
>
> Make sure you free all the memory with Set:
>
> Dim rsRecordset as ADODB.Recordset
>
> Set rs = New ADODB.Recordset
> rs.Open ...
> <your code here>
>
> rs.Close
> Set rs = Nothing
>
>
> --
> jma
>
>


From: Ken Halter on 12 Sep 2005 18:19
"Dib" <NOTdibsSPAM(a)comNOSPAMcast.net> wrote in message
news:ezDgMX%23tFHA.908(a)tk2msftngp13.phx.gbl...
> Thanks for your reply this did not help for I was already doing that.
>
> Thanks
> Dib

No real help here but.... I searched for that error number and it looks like
it's directly related to Crystal Reports. There *may* be something in one of
these that may help.

Results 1 - 7 of about 9 English pages for "-2147206398 ". (0.30 seconds)
http://www.google.com/search?as_q=&num=100&hl=en&btnG=Google+Search&as_epq=-2147206398+&as_oq=&as_eq=&lr=lang_en&as_ft=i&as_filetype=&as_qdr=all&as_occt=any&as_dt=i&as_sitesearch=&safe=images

--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
DLL Hell problems? Try ComGuard - http://www.vbsight.com/ComGuard.htm
Please keep all discussions in the groups..


 |  Next  |  Last
Pages: 1 2
Prev: MMControl
Next: Run-time error '20535'