lundi 9 août 2010 06:56
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,
Toutes les réponses
mercredi 14 mars 2012 22:11I met exactly same issue, any ideas?
mardi 27 mars 2012 11:42Can you please post your code?
jeudi 3 mai 2012 02:52ModérateurDid 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
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript
jeudi 3 mai 2012 20:55
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.
- Proposé comme réponse Mr. WhartyMicrosoft Community Contributor, Moderator vendredi 25 mai 2012 04:24
- Marqué comme réponse Mr. WhartyMicrosoft Community Contributor, Moderator lundi 28 mai 2012 01:06