We are currently moving our SQL Server 7 based database to SQL Server 2000 (Yeah progress) However in the mean time we have to support our SQL Server 7 database product. We currently have access to Visual Studio 2008 and I know that native support of connecting to SQL Server 7 does not exist. Does anyone know of any third party solutions that will allow me to develop with visual studio 2008 and SQL Server 7?
You should be able to use the classes in the System.Data.SqlClient namespace to connect to an instance of SQL Server 7 or above.