.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how can I open a sql compact 4.0 DB from VS 2010 server explorer ?

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
Hi, I've downloaded the latest sql compact 4.0 beta, and I follow the Scott Guthrie sample (http://weblogs.asp.net/scottgu/archive/2010/07/16/code-first-development-with-entity-framework-4.aspx). It is working as expected, the DB is created. However, I cannot open the DB in the server explorer of VS (neither from sql management studio). An error telling me the version of the file is not supported is thrown. Note that I only have the 3.5 version in the provider list in the add connection wizard. What is missing ? thanks in advance for the help. stevePaying back the community for its help by writing articles : Have a Nice Day.Net Blog

View Complete Post

More Related Resource Links

Windows Server 2008 R2 - "Open in Windows Explorer" only works in special cases



I am running SharePoint 2007 off a Windows 2008 R2 server and it seems to be running fine.

We're using another Windows 2008 R2 server for clients to login to (using remote desktop) and connect to the SharePoint site. However, whenever a client tries to use the "Open in Windows Explorer"-feature when handling documents, nothing happens. I have run through all the posts here and checked that all services, webdav modules, etc. are as they should be.

I found a fix recently, but it does not make a lot of sense. If I go directly to the site after logging in, it does not work (as expected). However, if I type in the direct path to the documents folder, \\sitename\cases, it opens just fine and if I open a new browser AFTER that, the "Open in Windows Explorer" feature now works perfectly fine.

Is there some way to fix this behavior other than adding a "net use" command to all startup scripts for all the users? It seems like I'm circumventing the problem rather than fixing it.

EDIT: We disabled UNC paths (because of security issues on the client server), but even if we tells you the path is disallowed, simply typing it in triggers the function to work (and still gives you access through SharePoint). Very odd.

Cannot connect 2010 Access 2010 Excel or PowerPivot to Mobile SQL(SQL Server Compact) - SDF files

I've believe I've installed everything to read Mobile SQL .SDF files.  I've insalled Sql Server Management Studio, Sql Server 2008 R2, .NET 4.0 Framework and just about everything else I've read to see the contents of an .SDF file created for what I read directly from these product sources as this DotNet Compact Framework is the greatest new SQL stuff on the planet.  I can connect using the Management Studio and see the TABLE Stucture easy enough and I can query using some simple SQL Commands from the Management Studio but what really bugs me is if this is all so wonderful, how come I cannot connect to what the SQL Server 2008 R2 Server type "SQL Server Compact" Authentication: "SQL Server Compact Authentication in Office 2010 Access, Excel or even "WOW" PowerPivot!  I've run across a couple 3rd party .SDF Readers - one that exports to Excel such as flyhoward.com  I'm growing old with all the work around import export stuff and just want to use PowerPivot to  excersise the data......or should I use something that actually works like Tableau??

[VB 2010 + sql server compact 3.5] SQL Insert Statement dosen't work (without any errors).


Hi guys!

I'm trying to insert some records in a sql server compact 3.5 database, but with no success.

The code:

Dim conn As New SqlCeConnection
Dim cmd As New SqlCeCommand

conn.ConnectionString = "datasource = .\Database1.sdf&quo

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

sql server 2010 && visual studi 2010


hi guys

I am using sql server 2010 for a project.I need to know if there is a property about the ON DELETE CASCADE option or i must write triggers???

Another problem is that i am using visual studio 2010 to write the aspx page but when i try to import the tables from the database it just imports the tables  but not the relations between them (i mean it doesn't import the primary/ foreign key property.) 

Any idea??? 


Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

Security Briefs: Add a Security Bug Bar to Microsoft Team Foundation Server 2010


Take a peek inside Microsoft's strict development security structure as Bryan Sullivan describes the objective security bug classification system?the "bug bar"?used by internal product and online services teams. He will show you how to incorporate this classification system into your own development environment using Microsoft Team Foundation Server 2010.

Bryan Sullivan

MSDN Magazine March 2010

Go Mobile: Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework


Developers have myriad options when it comes to creating solutions for mobile devices. One of the greatest challenges facing mobile developers is finding a compact yet robust local storage solution. SQL Server CE 2.0 promises to deliver on both fronts. This new release represents a tremendous leap in terms of features and performance over its predecessor. This article will review some of the platform and tools choices developers have today. The authors will compare and contrast the significant new features in SQL Server CE 2.0 with the previous release. Following that, they will build a sample app for illustration.

Mark Brown and David Meunier

MSDN Magazine January 2003

Getting Started with SQL Server Compact 4.0 and ASP.NET 4

The article Getting Started with SQL Server Compact 4.0 and ASP.NET 4 was added by tmorton on Monday, August 09, 2010.

While professional developers are waiting for the Visual Studio Tools and Designers for SQL Server Compact 4.0, I will show how impatient developers can include SQL Server Compact with ASP.NET applications, and use it from ASP.NET pages. Previously, you

cannot attach database from server explorer


Hello all,

In Server Management Studio, I am attempting to attach a database.  After selecting the database in the wizard

I receive an error: This file is in use, Enter a new name or close the file that's open in another program. 

I don't have SSMS open, and have restarted the computer to make sure the memory is cleared.  Not sure what to try next.  Any ideas?

Search Server Gatherer - Custom hierarchical protocol handler ISearchProtocol for MOSS 2010



Search server gatherer calls CloseAccessor() and shutdown() on ISearchProtocol after GetChunk() even if the FILTER_E_END_OF_CHUNKS is not returned. After calling shutdown() it stops calling the createaccessor() with new URL. I want to create a hierarchical indexing but I am not gatherer is not suporting this. The same piece of code is working fine in MOSS 2007, I am facing this issue in MOSS 2010 only. Is there anything changed in MOSS 2010 which is creating this issue?



When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open


When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.


SharePoint Enterprise Search Migration Tool for SharePoint Server 2010

Use this tool when you upgrade to SharePoint Enterprise Search to migrate search-related data, such as best bets, search scopes, and site collection search settings.

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Sample: SharePoint Server 2010: Aggregating Data Using BCS and .NET Assemblies

Use the BCS Data Aggregation sample with BCS in SharePoint Server 2010 and to aggregate data from two external systems.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend