The classes in the SqlClient Namespace have been specifically designed to
work with SQL Server 7 and up. There's a whole extra in those classes
(SqlConnection, SqlCommand, etc) specific to SQL Server which you won't find
in the classes under the OLEDb namespace (OLEDbConnection, OLEDbCommand,
etc). Also, various optmizations have been built into these classes keeping
SQL Server in mind which cannot be in the more generic OLEDb classes. You
should use the classes in the SqlClient namespace unless you have a good
reason not to. So I would suggest using SqlConnection for SQL Server 2000
and also using the remaining classes in the SqlClient namespace for data
access.
hope that helps..
Imran.
"Curtis" <cu****@synergyontheweb.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Which is preferred or what is the difference? SQLConnection or
OLEDbConnection.
We are connecting to data in MSSQL2000 primarily through stored
procedures.