Some General SQL server Questions

I see from the forums that MySQL 5 is not being tested, so I will end up using SQL server on my site, but I wondered about compatability.

I am still using VS2003 and .net 1.1, will that work with SQL Server 2005? I figure why go with 2000 then switch later if I can just start with 2005, as I'll eventually end up on .net 2

Looking at the MS Site for SQL server 2005, it requires .net 2.0 runtime, but I want sure if that is just for program execution.

 

Your site doesn't actually need the .NET 2.0 framework in order to use a SQL 2005 database. However, you do need the .NET 2.0 framework on your local computer to run the SQL 2005 tools, for example the SQL Server Management Studio.

DiscountASP.NET
www.DiscountASP.NET

 

You can connect to sql server 2005using asp.net 1.1. You will need to find a sql 2005 management tool to manage your databases. The old enterprise manager that connection to sql 2000 will not connect to sql 2005.



Joel Thoms

DiscountASP.NET
http://www.DiscountASP.NET

 

Thanks for the info... It seemed that .net 2 was just to run the tools etc, but wanted to make sure.