I currently working on VB.Net project. I would like ti know to SQL server 2005 is better or SQL 2000 for better connectivity. Also I want to know which of this can provide easy connectivity.
I'd go with 2005 for alot of reasons, but ease of connectivity is not one of them.
Possible to go to MSSQL 2008? That way, you can skip 2005 altogether. Their is a free Express 2008 available if you are interested.
SQL server 2005 is better for connectivity the code is
SqlConnection con = new SqlConnection("Server=You server name or comp name;Database=Yourdatabasename;Trusted_Connectopn=True");
SqlCommand cmd = new SqlCommand("Write your sql query here eg. select * from Table name");
DataSet ds = new DataSet(cmd,con);
SqlDataAdapter da = new SqlDataAdapter();
i hope this should work
^ How does that make SQL server 2005 better for connectivity?
Using DataSets nevertheless... For the OP, accessing any DB from .Net is the same, assuming you have the connector for that rdbms.