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

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

Requests to Microsoft after using SQL Server Compact

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
Visual Studio 2008 really places a lot of emphasis on SQL Server Compact.  I recently tried it out for a course project in Information Visualization.  I had some existing data I needed to visualize that was in Access Jet (MDB) format, which I wanted to copy into a new SDF file.  This should have been extremely straightforward to do, but it actually turned out to be a nightmare.

For comparison, I also have SQL Server Express 2008 installed, as well as Microsoft Access 2007.  To transfer a database from an MDB file to SQL Server Express 2008, I could do any of the following:
  • Start Access 2007.  Open the MDB file.  Click the "External Data" ribbon.  In the "Export" group, click "More", and click "ODBC database".  Select the DSN for SQL Server Express 2008.  Continue following the wizard.
  • Start Access 2007.  Open the MDB file.  Click the "Database Tools" ribbon.  In the "Move Data" group, click "SQL Server".  Follow the wizard.
  • Start the SQL Server Import and Export Wizard (a.k.a. DTS).  For "Data Source", choose "Microsoft Access" and select the file.  For "Destination", select from any of these three choices and choose the appropriate options:

More Related Resource Links

How to find students positions Based on their marks in Microsoft Sql Server Compact?


hi everybody! i have the following table in Microsoft Sql server Compact

1  aaa        90
2  bbb        90

3  ccc        80

4  ddd       75

5  eee      75

6  fff        70

7  ggg      68

I need to obtain the following results

ID  NAME    MARKS Position
1    aaa       90         1
2    bbb       90         1

3    ccc       80         2

4    ddd      75          3  

5   eee  

Microsoft SQL Server Compact Edition & CE6


I have an issue on a Janam barcode scanner (wifi) with an App I have written, it appears the realtime SQL login screen intermittently puts a call onto the network when we run it on CE6. When we run the same app on a Psion scanner with CE5 it works every time. I get the feeling its an SQL timing issue / lockout on the local client as no network traffic happens when it occurs, we restart the app and it sometimes works ??

The app is written in VS2008, the framework is v3.5, the cab on the terminal is sqlce.wce5.armv4i.CAB. there is currently no wce600 build but reading up the wce500 should be OK with ce6 ???

Anyone know of any SQL issues like this or what stops the connection to the SQL Server on the network?

Microsoft SQL Server Compact 3.5 Not Listed as a Connection in VB.NET 2008


SSCERuntime-ENU.msi is installed in "C:\ProgramFiles\Microsoft SQL Server Compact Edition" (confirmed). When trying to add a connection in VS.Net 2008 (Server Explorer> Data Connection > Add Connection > Data source)SQL Server Compact SQL Editionis not listed.

When trying to "Add Existing Item" (XXX.sdf) this message is displayed.

"The data provider requires to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated."

I've never used a local instance of SQL.

What am I missing

Thanks for any help.



CLR Integration With Microsoft SQL Server

Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

User Defined Functions in Microsoft SQL Server

User Defined Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual work units, and are created using standard SQL commands. Data transformation and reference value retrieval are common uses for functions. LEFT, the built in function for getting the left part of a string, and GETDATE, used for obtaining the current date and time, are two examples of function use. User Defined Functions enable the developer or DBA to create functions of their own, and save them inside SQL Server.

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

ISA Server 2004: Developing an Application Filter for Microsoft Internet Security and Acceleration S


The beta version of Internet Security and Acceleration (ISA) Server 2004 is now publicly available. It includes a rich SDK with several extensibility mechanisms that allow third parties to integrate their specialized solutions on top of the ISA platform. In this article, the author explores the application filter extensibility mechanism, which enables you to add high-level application layer filtering capabilities to ISA Server and to provide rich content filtering solutions. He also highlights the new features of the ISA Server 2004 SDK, then moves on to describe how to develop a basic application filter that monitors all data going through the ISA Server, and how to integrate a filter into the ISA Server management console to create a seamless interface experience for your users.

Yigal Edery

MSDN Magazine March 2004

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

Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0


What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000

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

"This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported"



I am getting the following error when i want to add a remote connection in the Server explorer:

'This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported'

what can be the problem. On Microsoft site i saw, you need to install following update: 'Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support'

But i have a Microsft SQL Express Server 2005 SP3...

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


Microsoft SharePoint Server 2010 Beta - Now Available!

SharePoint 2010 provides a robust development platform to rapidly build solutions using familiar tools like Visual Studio 2010 and SharePoint Designer 2010. Developers gain access to a rich set of out-of-the-box features such as Business Connectivity Services for read/write integration between application data, the web and Office 2010 client.

Microsoft SharePoint Server 2010: Deprecated Types and Methods

This resource contains text files that list all of the deprecated types and methods in Microsoft SharePoint Server 2010 and Microsoft Office SharePoint Server 2007.

WFE is out of synch? HTTP/1.1 200 OK Server: Microsoft


Encountering a strange situation here.... a little background.

We have 3 nodes.

Two servers are dedicated WFE's. Node 1 & Node 3. They are load balanced with a CSS.

One server is a dedicated indexer/crawler. Node 2.

We recently moved our database from a single server to a SQL cluster. We used the SQL Aliasing method as outlined here:


Everything works great, EXCEPT node3 seems to be out of synch. All existing sites are operating as expected. However, any new site collections I create only function on node1. If you hit node3 you recieve the following:

     HTTP/1.1 200 OK Server: Microsoft-IIS/7.0 Date: Fri, 27 Aug 2010 15:14:17 GMT Connection: close

It's like the site doesn't exist on node3. It doesn't matter if a new site collection is created in a new contentdb or an existing contentdb, it doesn't work on node3. On node1, new site collections are displayed as expected.

Here is what I have tried:

an IISreset on node3.
Initiated a full index.
Manually initiated a sync via stsadm
stsadm -listolddatabases is not listing any orphaned GUIds.
created a new contentdb.
flushed the c

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