Visual Studio and .NET Framework versions supported by SQL Server 2000


I would like to know which versions of Visual Studio and .NET Framework I have to use to connect to a SQL Server 2000 data server.

I have read that some versions are not compatible.

Thank you.

asked by Valerio C 14.06.2016 в 19:27

1 answer


You just have to make the connection to the database. .NET Framework Data Provider for SQL Server

You can use an App.config file

   <add name="default" 
        connectionString="Data Source=.;Initial Catalog=DBPrisma;User ID=sa;Password=xxx"/>

Make references to

using System.Data;
using System.Data.SqlClient;

I do not think you have any problems connecting to SQL 2000

internal class Conexion
    public static SqlConnection Conectar(string cnStr)
            string conn = ConfigurationManager.ConnectionStrings["default"].ToString();
            SqlConnection cn = new SqlConnection(conn);
            return cn;
        catch (Exception ex)
            throw new ArgumentException("Error de conexión", ex);


This is an example, I hope it helps you.

answered by 14.06.2016 / 19:41