Re: OUT OF MEMORY

Did you expand the size of the .SDF file when it was created? The default
size is 128KB.

--
____________________________________
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: How To Add/Update Record In ADO.NET
    ... If the row is already there (there is already someone with the same name in the database), ... Hitchhiker's Guide to Visual Studio and SQL Server ... "Jeff Gaines" wrote in message ... SQL Server Compact Edition or Express Edition come to mind. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... Okay, once the database is built, you have to get rights to access it. ... SSPI and "SQL Server" ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Which Method to Create a Database Do I Use?
    ... >> SQL Server Configuration Manager ... This mode assumes that the Windows User or IIS has rights to access the SQL Server itself and the database mentioned as the initial catalog in the Connection String. ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... "Jonathan Wood" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)