 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / November 2007why sdf file gets corrupted?
hello, i am using sql server ce 2.0.and my sdf file not working because of corrupting.why sdf file gets corrupted?and what can i do?i know how to repair sdf file but i want another solution,i dont want sdf file gets corrupted.please somebody help me! One solution is to move to SQL Compact (SQL CE 3) if that is an option for you.  SignatureGinny Caughey Device Application Development MVP > hello, > i am using sql server ce 2.0.and my sdf file not working because of > corrupting.why sdf file gets corrupted?and what can i do?i know how to > repair sdf file but i want another solution,i dont want sdf file gets > corrupted.please somebody help me! Sigh. You beat me to it... ;o Signature____________________________________ William (Bill) Vaughn Author, Mentor, Consultant, Dad, Grandpa Microsoft MVP INETA Speaker www.betav.com www.betav.com/blog/billva 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) ----------------------------------------------------------------------------------------------------------------------- > One solution is to move to SQL Compact (SQL CE 3) if that is an option for > you. [quoted text clipped - 4 lines] >> repair sdf file but i want another solution,i dont want sdf file gets >> corrupted.please somebody help me! Dnia Thu, 1 Nov 2007 07:53:42 -0400, Ginny Caughey [MVP] napisał(a): > One solution is to move to SQL Compact (SQL CE 3) if that is an option for > you. I'm interested. How to do this? I have a VS 2003 and VS 2005 and now I have to write application to Windows ce 4.3 powered device so I choose VS 2003 and SQL ce 2.0 but now I have a few problems with this database. Kate, Your question illustrates why I said "if that is an option for you". SQL Compact requires .NetCF v 2 or higher (or native code access) and is limited to running on devices that support that. So moving to version 3 is not always an option. I believe that support for CE 4.2 was added to CF 2.0 with service patch 1 however so perhaps that would work with 4.3 as well. SignatureGinny Caughey Device Application Development MVP > Dnia Thu, 1 Nov 2007 07:53:42 -0400, Ginny Caughey [MVP] napisał(a): > [quoted text clipped - 7 lines] > ce 4.3 powered device so I choose VS 2003 and SQL ce 2.0 but now I have a > few problems with this database. Dnia Thu, 1 Nov 2007 07:53:42 -0400, Ginny Caughey [MVP] napisał(a): > One solution is to move to SQL Compact (SQL CE 3) if that is an option for > you. I'm interested. How to do this? I have a VS 2003 and VS 2005 and now I have to write application to Windows ce 4.2 powered device so I choose VS 2003 and SQL ce 2.0 but now I have a few problems with this database. Kate, Perhaps this blog post is helpful: http://blogs.msdn.com/markprenticems/archive/2006/08/08/692624.aspx SignatureGinny Caughey Device Application Development MVP > Dnia Thu, 1 Nov 2007 07:53:42 -0400, Ginny Caughey [MVP] napisał(a): > [quoted text clipped - 7 lines] > ce 4.2 powered device so I choose VS 2003 and SQL ce 2.0 but now I have a > few problems with this database. Dnia Thu, 1 Nov 2007 14:19:41 -0400, Ginny Caughey [MVP] napisał(a): > Kate, > > Perhaps this blog post is helpful: > http://blogs.msdn.com/markprenticems/archive/2006/08/08/692624.aspx Thank you very much > Dnia Thu, 1 Nov 2007 14:19:41 -0400, Ginny Caughey [MVP] napisa?(a): > [quoted text clipped - 4 lines] > > Thank you very much I am on SQL Compact (SQL CE 3) and we still get corrupted SDF's. Any other solutions? Greg, Have you tried the 3.5 beta? Can you reproduce the behavior or do you have any idea what seems to trigger it? SignatureGinny Caughey Device Application Development MVP On Nov 1, 2:46 pm, Kate <tral...@wp.pl> wrote: > Dnia Thu, 1 Nov 2007 14:19:41 -0400, Ginny Caughey [MVP] napisa³(a): > [quoted text clipped - 4 lines] > > Thank you very much I am on SQL Compact (SQL CE 3) and we still get corrupted SDF's. Any other solutions? On Nov 2, 1:02 pm, "Ginny Caughey [MVP]" <ginny.caughey.onl...@wasteworks.com> wrote: > Greg, > [quoted text clipped - 18 lines] > I am on SQL Compact (SQL CE 3) and we still get corrupted SDF's. Any > other solutions? I have not tried the new release, we tend not to get in on the front of new releases. We have almost 500 devices syncing right now and I'll see one maybe once a month so it is manageable for us. If you look at the history of the SQL/CE package (it gets a new name each release), each proclaims, "No corruption -- we fixed it so it won't ever corrupt again". But all you got was the same ol' story, same ol' song and dance, my friend. And as before, someone, somewhere, _is_ going to tell you to use the "next, great release" and your problems will all be over. (LOL still) GJ [Fri, 02 Nov 2007 18:15:11 -0000]: >I am on SQL Compact (SQL CE 3) and we still get corrupted SDF's. Any >other solutions? Signature40th Floor - Software @ http://40th.com/ iplay.40th.com - Advanced PPC audio player phantasm.40th.com - The final destination |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.