[2003]Differentiate ODBC , OLEDB and SQL

[nUflAvOrS]

May i know the different between this three type of database connection component ?

Anyone can gv me the comparison, advantages , pros and cons :-)

What certain condition to use it ?

[jmcilhinney]

SqlClient is for SQL Server only and is more efficient than other providers when accessing SQL Server because it was written specifically for it and hooks in at a lower level. OleDb is for any data source that has an OLEDB provider, while OdbcClient is for any data source that has an ODBC driver.

You should always use the most specific ADO.NET provider that you can because that will lead to maximum efficiency. You should always use SqlClient for SQL Server unless you have a specific reason not to. Other databases have specific ADO.NET providers too, like Oracle and MySQL, and you should use them if you can. If you do not have access to a provider that is specific to your data source then you next choice should be OleDb. That's what is always used for Access via the Microsoft Jet OLEDB provider. If there is no other option then you should use OdbcClient, which is the lowest common denominator, with the ODBC driver for your data source.

[nUflAvOrS]

Thanks jmcilhinney which as cute as knut ...

but --> You must spread some Reputation around before giving it to jmcilhinney again.
can't gv you reputation anymore >.<

Thanks a lot to solve my confusion against it :=) u r kind and cute