not able to open my xxx.dbproj Files in VS

Hi,

I am getting lot of errors and not able to open dbproj files:

..................

.................

Microsoft.Data.Schema.SchemaModel.ModelStore.SqlCeManager..ctor(ModelCollation collation, IList`1 elementClasses, IList`1 annotationClasses, Int32 identifierPartMaxLength, Int32 maxIdentifierParts, String modelFileName, Boolean createNewModel)
   at Microsoft.Data.Schema.SchemaModel.ModelStore.ConstructModelStore(ModelCollation collation, String modelFileName, Boolean createNewModel)
   at Microsoft.Data.Schema.SchemaModel.ModelStore..ctor(ModelCollation collation, ModelSchema modelSchema, String modelFileName)
   at Microsoft.Data.Schema.SchemaModel.DataSchemaModel..ctor(ModelCollation collation, ModelSchema storeSchema, String modelFileName, ScriptCache scriptCache, ErrorManager errorManager)
   at Microsoft.Data.Schema.Sql.SchemaModel.SqlSchemaModel..ctor(ModelCollation collation, ModelSchema storeSchema, String modelFileName, ScriptCache scriptCache, ErrorManager errorManager, Boolean validationEnabled, SqlModelCapability modelCapability)
   at Microsoft.Data.Schema.Sql.SchemaModel.Sql100SchemaModel..ctor(Sql100DatabaseSchemaProvider databaseSchemaProvider, ModelCollation collation, ModelSchema storeSchema, String modelFileName, ScriptCache scriptCache, ErrorManager errorManager, Boolean validationEnabled, SqlModelCapability modelCapability, Boolean initializeBuiltIn, Boolean loadSql100ClrTypes)
   at Microsoft.Data.Schema.Sql.SchemaModel.Sql100SchemaModelConstructor.ConstructServiceImplementation()
   at Microsoft.Data.Schema.Build.DatabaseTaskHost.CreateDataSchemaModel()
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.InitializeTaskHost()
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.RecreateModel(Boolean dataSchemaModelWasRecycled)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.Reload()
   at Microsoft.VisualStudio.Data.Schema.Package.Project.Internal.ProjectNode.Load(String filename, String location, String name, UInt32 flags, Guid& iidProject, Int32& canceled)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.Load(String filename, String location, String name, UInt32 flags, Guid& iidProject, Int32& canceled)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.Internal.ProjectNode.InitializeForOuter(String filename, String location, String name, UInt32 flags, Guid& iid, IntPtr& projectPointer, Int32& canceled)
   at Microsoft.VisualStudio.Shell.Interop.IVsCreateAggregateProject.CreateAggregateProject(String pszProjectTypeGuids, String pszFilename, String pszLocation, String pszName, UInt32 grfCreateFlags, Guid& iidProject, IntPtr& ppvProject)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.Internal.ProjectFactory.CreateProject(String fileName, String location, String name, UInt32 flags, Guid& projectGuid, IntPtr& project, Int32& canceled)
   at Microsoft.VisualStudio.Shell.Flavor.FlavoredProjectFactoryBase.Microsoft.VisualStudio.Shell.Interop.IVsProjectFactory.CreateProject(String fileName, String location, String name, UInt32 flags, Guid& projectGuid, IntPtr& project, Int32& canceled)
   at Microsoft.VisualStudio.Shell.Interop.IVsSolution.OpenSolutionFile(UInt32 grfOpenOpts, String pszFilename)
   at Microsoft.VSDesigner.Project.UpgradeWizard.WizardMediator.UpgradeWizard()
   at Microsoft.VSDesigner.Project.UpgradeWizard.UpgradeWizard_Dialog.Finish()
   at Microsoft.VSWizards.WizardForm.Finish_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.RunDialog(Form form)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.VisualStudio.UIService.System.Windows.Forms.Design.IUIService.ShowDialog(Form form)
   at Microsoft.VSWizards.WizardForm.ShowDialog()
   at Microsoft.VSDesigner.Project.UpgradeWizard.UpgradeWizard_Dialog.ShowWizard()
   at Microsoft.VSDesigner.Project.UpgradeWizard.UpgradeWizard.Execute(Object Application, Int32 hwndOwner, Object[]& ContextParams, Object[]& CustomParams, wizardResult& wr)
   at Microsoft.VisualStudio.TeamFoundation.VersionControl.IVersionControlProvider.OpenFromSCC(String solutionFile, String localDir, String version, VersionControlOpenFromSccOverwrite overwriteMode)
   at Microsoft.VisualStudio.TeamFoundation.VersionControl.HatPackage.OpenSolutionWithWorkspace(Workspace workspace, String serverItem, VersionSpec spec)
   at Microsoft.VisualStudio.TeamFoundation.VersionControl.ExplorerSccVS.OnView()
   at Microsoft.TeamFoundation.VersionControl.Controls.ExplorerScc.OpenSelectedNodeHandler()
   at Microsoft.TeamFoundation.VersionControl.Controls.ListViewExplorer.OpenSelectedNode()
   at Microsoft.TeamFoundation.VersionControl.Controls.ListViewExplorer.OnMouseDoubleClick(MouseEventArgs e)
   at System.Windows.Forms.ListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
[Pid=6120;Tid=1;Time=11:27:30]: Error: 16384: Failed to initialize DataSchemaModel Microsoft.Data.Schema.SchemaModel.ModelException: InternalError: SqlCeManager could not be initialized. ---> System.Data.SqlServerCe.SqlCeException: Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details. ---> System.DllNotFoundException: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
   at System.Data.SqlServerCe.NativeMethods.GetSqlCeVersionInfo(IntPtr& pwszVersion)
   at System.Data.SqlServerCe.NativeMethods.LoadValidLibrary(String modulePath, Int32 moduleVersion)
   at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries()
   --- End of inner exception stack trace ---
   at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries()
   at System.Data.SqlServerCe.SqlCeEngine..ctor()
   at Microsoft.Data.Schema.SchemaModel.ModelStore.SqlCeManager..ctor(ModelCollation collation, IList`1 elementClasses, IList`1 annotationClasses, Int32 identifierPartMaxLength, Int32 maxIdentifierParts, String modelFileName, Boolean createNewModel)
   --- End of inner exception stack trace ---
   at Microsoft.Data.Schema.SchemaModel.ModelStore.SqlCeManager..ctor(ModelCollation collation, IList`1 elementClasses, IList`1 annotationClasses, Int32 identifierPartMaxLength, Int32 maxIdentifierParts, String modelFileName, Boolean createNewModel)
   at Microsoft.Data.Schema.SchemaModel.ModelStore.ConstructModelStore(ModelCollation collation, String modelFileName, Boolean createNewModel)
   at Microsoft.Data.Schema.SchemaModel.ModelStore..ctor(ModelCollation collation, ModelSchema modelSchema, String modelFileName)
   at Microsoft.Data.Schema.SchemaModel.DataSchemaModel..ctor(ModelCollation collation, ModelSchema storeSchema, String modelFileName, ScriptCache scriptCache, ErrorManager errorManager)
   at Microsoft.Data.Schema.Sql.SchemaModel.SqlSchemaModel..ctor(ModelCollation collation, ModelSchema storeSchema, String modelFileName, ScriptCache scriptCache, ErrorManager errorManager, Boolean validationEnabled, SqlModelCapability modelCapability)
   at Microsoft.Data.Schema.Sql.SchemaModel.Sql100SchemaModel..ctor(Sql100DatabaseSchemaProvider databaseSchemaProvider, ModelCollation collation, ModelSchema storeSchema, String modelFileName, ScriptCache scriptCache, ErrorManager errorManager, Boolean validationEnabled, SqlModelCapability modelCapability, Boolean initializeBuiltIn, Boolean loadSql100ClrTypes)
   at Microsoft.Data.Schema.Sql.SchemaModel.Sql100SchemaModelConstructor.ConstructServiceImplementation()
   at Microsoft.Data.Schema.Build.DatabaseTaskHost.CreateDataSchemaModel()
    CallStack=   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at System.Diagnostics.TraceEventCache.get_Callstack()
   at Microsoft.Data.Schema.Common.Diagnostics.TSDTraceListenerDecorator.TraceEvent(TraceEventCache eventCache, String source, TraceEventType severity, Int32 id, String message)
   at System.Diagnostics.TraceSource.TraceEvent(TraceEventType eventType, Int32 id, String message)
   at Microsoft.Data.Schema.Build.DatabaseTaskHost.CreateDataSchemaModel()
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.InitializeTaskHost()
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.RecreateModel(Boolean dataSchemaModelWasRecycled)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.Reload()
   at Microsoft.VisualStudio.Data.Schema.Package.Project.Internal.ProjectNode.Load(String filename, String location, String name, UInt32 flags, Guid& iidProject, Int32& canceled)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.DatabaseProjectNode.Load(String filename, String location, String name, UInt32 flags, Guid& iidProject, Int32& canceled)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.Internal.ProjectNode.InitializeForOuter(String filename, String location, String name, UInt32 flags, Guid& iid, IntPtr& projectPointer, Int32& canceled)
   at Microsoft.VisualStudio.Shell.Interop.IVsCreateAggregateProject.CreateAggregateProject(String pszProjectTypeGuids, String pszFilename, String pszLocation, String pszName, UInt32 grfCreateFlags, Guid& iidProject, IntPtr& ppvProject)
   at Microsoft.VisualStudio.Data.Schema.Package.Project.Internal.ProjectFactory.CreateProject(String fileName, String location, String name, UInt32 flags, Guid& projectGuid, IntPtr& project, Int32& canceled)
   at Microsoft.VisualStudio.Shell.Flavor.FlavoredProjectFactoryBase.Microsoft.VisualStudio.Shell.Interop.IVsProjectFactory.CreateProject(String fileName, String location, String name, UInt32 flags, Guid& projectGuid, IntPtr& project, Int32& canceled)
   at Microsoft.VisualStudio.Shell.Interop.IVsSolution.OpenSolutionFile(UInt32 grfOpenOpts, String pszFilename)
   at Microsoft.VSDesigner.Project.UpgradeWizard.WizardMediator.UpgradeWizard()
   at Microsoft.VSDesigner.Project.UpgradeWizard.UpgradeWizard_Dialog.Finish()
   at Microsoft.VSWizards.WizardForm.Finish_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ThreadContext.LocalModalMessageLoop(Form form)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason

..........

...............

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shweta Lodha12y ago
Accepted answer
I think, issue is with your SQL server edition. Please check this:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/47dd45b6-c464-4b2a-aff0-2c6ef475e685/visual-studio-2010-sp1-cannot-open-dbproj-files?forum=sqlce
0
Himha12y ago
Hello Lakshmanan Sethu,
The answer you posted is copied from the link which is pasted by Shweta Lodha. anyways thanks.
0
Lakshmanan Sethu Sankaranarayan12y ago
please check the resolution I found that on my file system the there were no Microsoft SQL Server Compact Edition x86 binaries on the system. I downloaded the installer and ran a repair and the issue was fixed. The installer was located here
0