Click to See Complete Forum and Search --> : Sql Ce Out_of_memory


blb.bose
April 4th, 2007, 02:59 AM
Hi all,

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.

TIA,

Bose

exterminator
April 8th, 2007, 08:05 AM
Is it consistently 70 records or more or less? What is the successful count of inserts if you remove the indexes?