RE: SQLServerCE 3.1 and Vista Ultimate

Look at this detailed guide to get the all required components right:
http://blogs.msdn.com/stevelasker/archive/2007/08/07/configuring-visual-studio-2005-for-use-wtih-sql-server-2005-compact-edition.aspx

--
Erik Ejlskov Jensen - MCTS: Mobile App Dev


"Christopher Pisz" wrote:

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

  • VS 2003 + opening a connection to SQL SERVER 2000 database
    ... I have Windows XP Pro with SP2 and all the updates. ... it errors out saying it "sql server does ... the old development machine. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connect to SQL 2005 database on local network fails
    ... hope someone can give us some clue about this odd problem. ... application to access a dedicated SQL server (not the one on my dev ... access the SQL server on the development machine it fails. ... development environment then the emulated pocket pc should be able to ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Connect to SQL 2005 database on local network fails
    ... As a follow up to my own posting I have found some odder problems. ... application to access a dedicated SQL server (not the one on my dev ... access the SQL server on the development machine it fails. ... development environment then the emulated pocket pc should be able to ...
    (microsoft.public.dotnet.framework.compactframework)
  • 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, ... Why cannot I not develop using SQL Server Compact 3.1 and VS 2005 just ...
    (microsoft.public.sqlserver.ce)
  • Create ODBC to SQL SErver 2008 in Windows Vista Ultimate
    ... I have make one SQL Server 2008 data Base in myWindows Vista Ultimate and ... I'm trying yo create one ODBC for connect to my data base. ... Error de SQL Server: 2 ...
    (microsoft.public.sqlserver.connect)
Loading