welcome_alexray — 2011-04-06T07:27:15-04:00 — #1
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.
wwb_99 — 2011-04-06T10:53:29-04:00 — #2
I'd go with 2005 for alot of reasons, but ease of connectivity is not one of them.
jason__c — 2011-04-06T23:15:36-04:00 — #3
Possible to go to MSSQL 2008? That way, you can skip 2005 altogether. Their is a free Express 2008 available if you are interested.
git_solutions — 2011-04-07T00:45:40-04:00 — #4
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
chieftain — 2011-04-10T22:38:53-04:00 — #5
^ How does that make SQL server 2005 better for connectivity?
praetor — 2011-04-11T02:38:31-04:00 — #6
Using DataSets nevertheless... For the OP, accessing any DB from .Net is the same, assuming you have the connector for that rdbms.