eVB with SqlServerCE

Discussion in 'microsoft.public.sqlserver.ce' started by Paolo, Sep 19, 2005.

  1. Paolo

    Paolo Guest

    I'm writing an application in eVB3 that will use a SqlServerCE
    database.After
    many operation with my database this error appear "Not enough storage is
    available to complete this operation".
    I will destroy my object (SET rs=NOTHING , SET cn=NOTHING) but the i have
    the same problem!!!!!!
    Please help me.
    Thank's
     
    Paolo, Sep 19, 2005
    #1
    1. Advertisements

  2. Pete Vickers [MVP], Sep 19, 2005
    #2
    1. Advertisements

  3. SET rs=NOTHING just does not mean destroying of object. It just means that
    you are losing the references to the object. Of course, I agree that
    Garbage Collector should pick up them but it takes times. So, I prefer you
    to call a Dispose or Free function which ever is applicable to explcitly
    destroy the object.

    Once you do that I hope you will get rid of "Not enough storage is available
    to..."

    Thanks,
     
    Laxmi Narsimha Rao ORUGANTI \(MSFT\), Sep 20, 2005
    #3
  4. If you are updating data, make sure to have a Base Table cursor. Take a
    look at the Books Online for syntax.

    You can access SQL Server CE Knowledge Base articles at:

    http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO
    ( select ' SQL Server CE ' as the product )

    Thank you!
    Syed N. Yousuf
    Microsoft Developer Support Professional

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Syed N. Yousuf [MS], Sep 26, 2005
    #4
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.