SQLServerCE 3.1 and Vista Ultimate

I've been struggling to get the prerequisites correct for some time now.



What I have:

I have Visual Studio 2005 Professional

Express editions of VS do not suit my needs



I have Vista Ultimate 64 bit as my OS, on my development machine



What I need:

To embed a SQL database within my application

preferably integrated with my IDE



What I want to avoid:

Spending $700 to upgrade VS for the purposes of one project

Having to develop on a differant OS for the purposes of one project



My problem:

Upon a fresh install of Visual Studio 2005 on my development machine, SQL
Server Compact edition does not appear in the refrences list in the C# IDE,
nor does it appear as an option when creating a DB through server explorer,
nor do any of the other integrated features seem to work when following the
documentation.



However, when I install on my laptop which happens to run Vista 32 bit,
everything is fine, appears where expected and works as expected.



Why cannot I not develop using SQL Server Compact 3.1 and VS 2005 just
because I am running a 64 bit OS? Vista Ultimate was the most expensive
option, I'd expect it to be the superset of eveything. Am I missing
something?



I also tryed SQL Server 3.5, but it will not integrate with VS 2005 and
requires VS 2008 for all features.



I develop other projects on this machine and environment with no problem at
all, why such problems when it comes to SQL Server? Did MS just expect all
developers to drop $800 for an upgrade along with $600 for an OS? I do not
run a company, I don't have that kind of money.


.

Relevant Pages

  • RE: SQLServerCE 3.1 and Vista Ultimate
    ... I have Vista Ultimate 64 bit as my OS, ... Upon a fresh install of Visual Studio 2005 on my development machine, ... nor do any of the other integrated features seem to work when following the ... Why cannot I not develop using SQL Server Compact 3.1 and VS 2005 just ...
    (microsoft.public.sqlserver.ce)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Thanks for posting it. ... Hitchhiker's Guide to Visual Studio and SQL Server ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Ado.net DataSet Refresh
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... records but after insertion it does not refresh it. ...
    (microsoft.public.dotnet.framework.adonet)
Loading