Which VStudio 2008 Edition Can Connect to SQL Server?



Can someone tell me which edition of Visual Studio 2008 will allow the
Database Explorer to connect to a SQL Server database? I am currently
running C# 2008 Express Edition, but I can only connect to an Access
Database File, SQL Server Compact 3.5 and SQL Server Database File. I
would like to connect to a SQL Server instance (specifically SQL
Server 2000), not the database file. I tried getting it to work with
Visual Studio 2008 trial and it worked fine, but my understanding is
that the trial is actually the Profession edition. Will the Standard
edition also connect to SQL Server instances? The information on
microsoft.com isn't very clear on this matter. If I can make do with
Standard edition, I prefer to go that route because most of the
features on Professional edition are not useful for me. Also, I can't
recall if I was able to connect to SQL Server 2000 or 2005 with the
VStudio trial. Does VStudio 2008 have support for connecting to SQL
Server 2000 using the Database Explorer? That's what I'm using right
now because I have Windows SBS 2003 (not RC2). Thanks in advance!

John
.



Relevant Pages

  • 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: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... The SQLCe engine requires the 2.0 Framework. ... Hitchhiker's Guide to Visual Studio and SQL Server ... However, it does build the SSCE database, just some of the definitions are ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)

Loading