Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

MSDN Blog Postings » 2007 » August » 06

MSDN Blog Postings » 2007 » August » 06 — Tue, 07 Aug 2007 05:20:09 GMT

PingBack from http://msdnrss.thecoderblogs.com/2007/08/06/

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Richard Simmons — Tue, 07 Aug 2007 09:50:56 GMT

Thanks for latest info

My Microsoft SQL Server 2005 Compact Edition [ENU] still shows ENU (As do a number of other programmes)

Does this mean that the latest edition is NOT on the MS Download page or have I got the correct version

have eamil a coy of my add programmes

Thanks

Keep up the brilliant work

Richard

Steve Lasker details how to configure Visual Studio 2005 for SQL Server 2005 Compact Edition

David Kline — Tue, 07 Aug 2007 21:13:08 GMT

While I am not (yet) much of an expert on databases, I was excited to see Steve Lasker post instructions

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Steve.Lasker — Thu, 09 Aug 2007 00:50:30 GMT

Bill Vaughn graciously gave me a bunch of feedback on some gotchas that he and others have ran into. So, I’ve updated the post with several images, verification steps, qualifiers for Express and the Visual Studio SP1 for Vista link. Thanks again Bill

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Jeffry van de Vuurst — Tue, 04 Sep 2007 02:05:31 GMT

Thanks for the article. I have a problem though. I've followed all the steps, but in the Add Reference screen I still see the SqlServerCe dll with version 3.0.3600.0 even though the actual file version is 3.0.5300.0!

Then when I add the reference it tries to reference 3.0.3600.0. I installed Sql Compact using the cab file and I get a runtime error because it looks for version 3600, but I only have 5300 on my device.

Any idea how I can get rid of the 3.0.3600.0 reference in Visual Studio?

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Steve.Lasker — Tue, 04 Sep 2007 08:15:11 GMT

Hi Jeffery,

The solution I described is actually for desktop scenarios. The SQLce 3.1 release was really the 3.0 SQL Mobile release for the desktop. There wasn't anything substantial, other than some bug fixes for the device version.

For devices, you don't want to manually reference the files in the c:\program files directory as those are for desktop, and will vconfuse the fx runtime trying to resolve the desktop managed provider and desktop ado.net stack.

Steve

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Jeffry van de Vuurst — Tue, 04 Sep 2007 10:43:12 GMT

Hi Steve,

I thought I knew I understood how it worked, but now I'm not so sure anymore :).

When I installed the Sql Compact tools, it also updated the cab files in c:\program files\microsoft visual studio 8\smartdevices\sdk\sql server\mobile\v3.0 etc.

When I use these cab files to deploy, it deploys the Sql Compact Core and not Sql Mobile 2005 anymore. And because the reference is still to version 3600 it fails.

I could just keep deploying Sql Mobile 2005 to the device and not upgrade. Are you saying there's no substantial differences between the two for devices? Because then I might as well stay with 2005. But still, this confuses me a lot.

Thanks,

Jeffry

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Marcin Smolka — Mon, 10 Sep 2007 13:21:00 GMT

Hello,

I have smart devices programing installed (I can choose any smart device application project from visual studio create project option), I have also SP1 installed for visual studio, but I still have error that tools can not be installed. I've also rerun setu and checked if smart devices are selected and everything is correct. But I still have that error.

Have you any idea why it can happen?

Thanks

Marcin

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Steve.Lasker — Thu, 13 Sep 2007 06:38:08 GMT

Hi Marcin,

Can you verify you have the SQL Server Mobile tools installed? You should see it in Add/Remove programs. The SQL Server Compact Tools are an update to the SQL Mobile tools. So, if you uninstalled the SQL Mobile tools, or somehow didn't get them installed, the update to SQL Server Compact tools won't work.

Steve

Sql server Ce 3.1 .. istallazione faticosa.

Alkampfer's Place — Mon, 01 Oct 2007 08:31:35 GMT

Sql server Ce 3.1 .. istallazione faticosa.

ExternalBlogs — Mon, 01 Oct 2007 08:46:26 GMT

Stamane debbo fare un lavoro urgent per un cliente, sviluppo su mobile e necessità di sql server, vado

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

grauenwolf — Tue, 02 Oct 2007 23:49:56 GMT

Thank you so much! I was tearing my hair out trying to get it to work.

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Stephan.Kauss@Ticketcorner.com — Fri, 07 Dec 2007 16:51:38 GMT

Is it possible to use the SQL Server 2005 Compact Edititon 3.5 with Visual Studio 2005 ?

And if yes pleas let me know how.

Thanks Regards

Stephan

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Steve.Lasker — Sat, 08 Dec 2007 22:03:30 GMT

Hi Stephan,

Yes, you can use SQL Server Compact 3.5 with Visual studio 2005... sort of. ...meaning, you can use the code scenarios, add references, instance objects, etc. However, tooling for SQL Server Compact 3.5 is limited to VS 2008.

Steve

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

ekoseos — Tue, 18 Dec 2007 12:06:12 GMT

Hello,

You are saying SQL Server CE 3.5 can be used with VS 2005? The reason is that the mobile I am deploying too has its own SDK (C++) that can only integrate with VS2005 (no VS2008 upgrade as yet); What do you mean by tooling? Can I use SQL Server 2005 Management Studio to access CE 3.5 as the "tooling".

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Steve.Lasker — Wed, 19 Dec 2007 04:57:58 GMT

Hi Ekoseos,

What I mean by "tooling" is the VS Designers including the DataSet designer, Server Explorer and Connection Dialogs. Basically any tool (VS or Managmenet Studio) that has to display UI to communicate with SQLce will only be enabled as described:

VS/Management Studio 2005 = SQL Server Compact 3.1

VS/Management Studio 2008 = SQL Server Compact 3.5

Hope that helps explain,

Steve

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Peter — Thu, 03 Jan 2008 00:13:27 GMT

So to work with the DB files for SqlCE (3.5) we need to install the Express version of C# (as an example) and edit them from there, correct? I guess you might tell us just to upgrade to VS 2008 :) ?

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Steve.Lasker — Wed, 09 Jan 2008 18:14:38 GMT

Hi Peter,

ummmm, yes. Due to tight schedules and resource constraints, we were unable to support multi-targeting of tooling.

...but, we did get the express tools integrated with SQLce 3.5, so you don't have to purchase the professional product just to get started.

Steve

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

Clint Teune — Wed, 23 Jan 2008 12:20:38 GMT

Can SQL Compact edition work with Visual Studio Tools for Office. I thought that VSTO sat above Visual Studio Standard and along-side VS Pro but the SQL Ce tools are not available during the installation process.

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

WideCharacter — Sat, 14 Feb 2009 00:08:06 GMT

Hi Steve,

The very end of you post says,

"Note, you no longer need to manually add a file based reference to the System.Data.SqlServerCe.dll. When you install the SQL Server Compact Tools for Visual Studio 2005 SP1, a entry is made in the registry enabling the Add Reference dialog to properly display the System.Data.SqlServerCe reference in the .NET tab."

I'm not seeing this behavior. The .Net tab continues to offer SQL CE 3.0 for SqlServerCe and SqlClient. I've seen this on my own box, and another on which I installed VS 2005 SP1 for the first time.

Can this be tweaked manually?

Thanks

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

meannn — Sun, 26 Apr 2009 05:24:43 GMT

That is the point > VS/Management Studio 2005 = SQL Server Compact 3.1

VS/Management Studio 2008 = SQL Server Compact 3.5

Thanks...

re: Configuring Visual Studio 2005 for use with SQL Server 2005 Compact Edition

meannn — Sun, 26 Apr 2009 05:25:35 GMT

And you are totally right that, The SQLce 3.1 release was really the 3.0 SQL Mobile release for the desktop...