Re: OUT OF MEMORY

Hi,

"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxx> wrote in message
news:eLG$w7SeHHA.4020@xxxxxxxxxxxxxxxxxxxxxxx
Sure it does, but this is NOT SQL Server (despite the name). This engine
was originally designed to work on a phone or PDA where memory is very
limited. You have to set the SQLCe database's upper boundary to make sure
the database does not get out of hand.

OK but, you are saying that the default upper limit is 128k when created? I
guess it depends then on how the DB is created. I created my database using
Query Analyzer 2.0 and I have seen it grow to 30MB w/o me touching any
"upperlimit" of it. One last thing: If this upper limit is set to say 128K
and one attempts to go past that by issuing an INSERT, the error that comes
back is E_OUTOFMEMORY? Thanks.

Marius



--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Marius Prisecaru" <prisasm@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:uOVFw3SeHHA.4564@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxx> wrote in message
news:uhiHI8tdHHA.4388@xxxxxxxxxxxxxxxxxxxxxxx
Did you expand the size of the .SDF file when it was created? The
default size is 128KB.

Maybe I am missing something, but as you write records to the .sdf file,
shouldn't this file expand automatically? That's the behavior I see here
[SQL Server CE 2.0/3.0, OLEDB, eVC++3.0/4.0/VS2005].

Marius



--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest
book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Sasi" <mailtousk@xxxxxxxxx> wrote in message
news:1175687327.564846.192940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm Sasikumar, started to work with SQL CE DB.

I have seen your postings in forum regarding the OUTOFMEMORY problem,
we are also facing the same problem. If could help us on how to solve
then it would be more useful for us.

We are working with the following environment.

OS: Win CE 3.0

Db: SQL DB CE 2.0

Embedded Visual C++ 3.0 ( eVC++ 3.0)

Device Name: CASIO IT700



We want to create a database in the device and access the records in
the table. We have created a database then the table with index and
then tried to insert the records into the table. We read the records
from the CVS file and frame the query then insert them into the table.
We have done this using the API's and not through the query analyzer.



We were able to create the DB, Tables successfully. We then read the
records one by one from the CSV file, we were able to insert up to 70
records then we ended up with the error E_OUTOFMEMEORY error. What
should be the problem for this.

We are creating the DB in the storage card which is 512MB capacity and
has 450 MB free space.

Regards

Sasikumar









.

Relevant Pages

  • Re: What are OleDbParameter names with Original_ prefix?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Since the table has a primary key column, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET Transaction
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Client transactions put too much schema-dependent, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Performance problems with OracleDataReader
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... referencing the columns by ordinal is far faster than using strings. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Very slow
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.sqlserver.ce)
  • Re: ADO.NET Transaction
    ... The SqlBulkCopy class can take anything you can expose with a DataReader and send it to SQL Server in a single high-speed operation. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Client transactions put too much schema-dependent, ...
    (microsoft.public.dotnet.framework.adonet)