Strange Problem: .sdf 128MB Filesize Limit

Hi guys,

I have this stange problem after changing .Net CF 1.1 to 2.0.

I create the mobile database within the PPC, reading data from text files and use INSERT INTO query and build up the database. I don't recall having the 128MB filesize limit using CF 1.1 but after changing to CF 2.0 for my codes.

Dim sqlCreateTableW As Data.SqlServerCe.SqlCeCommand = ssceconn.CreateCommand()sqlCreateTableW.CommandText = "CREATE TABLE MyTbl(id integer IDENTITY(0,1) PRIMARY KEY, data ntext, ref ntext)"
sqlCreateTableW.ExecuteNonQuery()
Dim sqlIndexTableW As Data.SqlServerCe.SqlCeCommand = ssceconn.CreateCommand()
sqlIndexTableW.CommandText = "CREATE INDEX IdInd ON MyTbl (id ASC)"
sqlIndexTableW.ExecuteNonQuery()
Dim sqlInsertRowW As Data.SqlServerCe.SqlCeCommand = ssceconn.CreateCommand()

looping the code below

sqlInsertRowW.CommandText = "INSERT INTO MyTbl(data, ref) VALUES('" & str1 & "', '" & str2 & "')"
sqlInsertRowW.ExecuteNonQuery()

I have 3 columns in the table, including an index (id). I found this link http://msdn2.microsoft.com/en-us/library/ms172451.aspx and it states that:

1The default maximum size is 128 MB.
2This limit is applied only if a storage engine temporary table is used for implementing ORDER BY. If the Query Processor can leverage an existing index, there is no maximum column-number limit.

Did I do anything wrong or missed out something?


Regards.