<Unable to read data>

Question

Hi People,

I am working on a SDF database (SQL Server Compact edition) of roughly 200mb and 11,87,506 rows in it.

When I do Select to get say around 5000 rows of data, it returns 4649 rows and almost at the end there is a row with "<Unable to read data>" written at all the columns.

This is causing a lot of pain.... What cd be the reason for this and how do I get over it? Please Help me....

I run a C# code to Insert ~5000 rows of data to this DB...

 

Waiting for response

Thanks in advance,

Vishruth

Answer 1

I met exactly same issue, any ideas?

Answer 2

Can you please post your code?

Answer 3

Did you end up finding out what the problem was?

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 4

how are you accessing the SDF database and do you get the error message when calling the SQL Server CE API or by another component - eg. WCF etc. ?

if you're using a layer between your application and SDF, please try to read the data via SQL Server API and check if you can get the data without an error.

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.