OLEDB vs SQLClient

[Lost User]

Please tell me the difference of...OLEDB vs SQLClient..which one is better and why?

Sujit

[Kunal P]

these both are providers for different types of database access. SQLClient is a provider specially optimized to work with MS SQL server, and is very well recommended to use with sql server. on the other habd OleDB is used with MS ACCESS. The choice is entirely yours, as to which database you want to use. accordingly u will have to chose the provider

Kunal