Native Error 28609
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Native Error 28609 SQL Server > SQL Server Compact Question 0 Sign in to vote good morning I have the following problem when I try to open my database on the PDA I get the native Error 28609 You are trying to access an older version of SQL Server Compact 3.5 database . If this is a SQL Server CE 1.0 or 2.0 database , run upgrade.exe . If this is a SQL Server Compact 3.5 database , run Compact / Repair I would like to know how I run option for Compact / Repair , and I have no doubt about that and I would believe that would solve my problem sql compact I use is the 3.5 thanks Tuesday, March 29, 2016 2:01 PM Reply | Quote Answers 0 Sign in to vote Actually, the SQL Server Compact toolbox supports both Repair and Compact! And it also has a tool to dectect the sdf file version... Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com Edited by ErikEJMVP, Moderator Tuesday, March 29, 2016 5:08 PM Proposed as answer by Alberto P. Silva Wednesday, March 30, 2016 11:37 AM Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Wednesday, April 06, 2016 9:36 AM Tuesday, March 29, 2016 5:07 PM Reply | Quote Moderator 0 Sign in to vote Download the SQL Server Compact Toolbox from Codeplex,this seems to be the latest release for the standalone version: http://sqlcetoolbox.codeplex.com/releases/view/104781 Erik, who created and maintains that tool, can better assist you if you need any help installing or using the tool.Alberto Silva / www.moving2u.pt - R&D Manager / Former Microsoft MVP (2003-2015) Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator Wednesday, April 06, 2016 9:36 AM Wednesday, March 30, 2016 11:42 AM Reply | Quote A
User Location: Joined on: 12-Dec-2006 14:44:05 Posted: 2 posts # Posted on: 03-Jul-2013 10:49:30. Hi, i have the same problem as in thread " SQL Compact (CE) 4.0 support"LLBLGEN: Version 2.6 Build October 9, 2009VisualStudio: 2012 https://social.msdn.microsoft.com/Forums/en-US/d6d2aaf2-46b3-45b4-961e-9b4fd69140ed/native-error-28609?forum=sqlce Update1SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll:2.6.12.1015Template group: Adapter.NET FW version: 4.0(I guess i need the two updated dlls that support DQE instantiation of ce40 dbproviderfactory) I have tried to connect to SQL4.0 with LLBLGen 2.6 and I have set the DQE to CE35 and I get https://llblgen.com/tinyforum/Messages.aspx?ThreadID=22036 the following error:System.Data.SqlServerCe.SqlCeException was unhandled HResult=-2146233087 Message=Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = \\?\C:\KSADA\DAL\ksada.sdf ] Source=SQL Server Compact ADO.NET Data Provider NativeError=28609 StackTrace: at System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent) at System.Data.SqlServerCe.SqlCeConnection.Open() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.OpenConnection() at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.PrepareQueryExecution(IQuery queryToExecute, Boolean forceConnectionSet) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFactory2 entityFactory, IEntityCollection2 collectionToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo, Boolean allowDuplicates, IEntityFields2 fieldsUsedForQuery) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollectionInternal(IEntityCollection2 collectionToFill, IRelationPredicateBucket& filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses) at Core.Communicator.ConstructVarOnlineList() in c:\KSADA\Core\Communicator.cs:line 182 at Core.Communicator..cto
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://stackoverflow.com/questions/12326952/visual-studio-2010-using-sqlce-3-5-but-project-has-4-4-sdf-file Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up visual studio 2010 using SQLCe 3.5 but project native error has 4.4 sdf file up vote 0 down vote favorite I have added sql compack edition v4.0 file on my windows phone 7 project in visual studio 2010. I copied the data base from application folder to isolated storage, now while querying it gives this thing countyList.Count() A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in Microsoft.Phone.Data.Internal.dll 'countyList.Count()' threw an exception of type 'System.Data.SqlServerCe.SqlCeException' base {System.Data.Common.DbException}: {"Incompatible native error 28609 Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = AMEDatabase.sdf ]"} _customMessage: "Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = AMEDatabase.sdf ]" _errors: {System.Data.SqlServerCe.SqlCeErrorCollection} Errors: {System.Data.SqlServerCe.SqlCeErrorCollection} HResult: -2147467259 Message: "Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = AMEDatabase.sdf ]" NativeError: 28609 Source: "SQL Server Compact ADO.NET Data Provider" when i added this file from my visual studio how this thing can use 3.5 version?? what to do? could it be coz the System.Data.Linq file?(my project has v 2.0 of this dll) windows-phone-7 sql-server-ce versioning share|improve this question asked Sep 8 '12 at 0:19 Mayur 1,91442255 1 Windows Phone only Works with 3.5 databases –ErikEJ Sep 8 '12 at 6:22 @ErikEJ Thanks Erik –Mayur Sep 8 '12 at 10:37 @ErikEJ Please post ur comment as an answer so that i can select it –Mayur Sep 8 '12 at 11:57 add