Ashish Misra

• Apr 14th, 2006

 

OleDBDotNet Provider can be used to connect to any DataSource but OleDb SQL SERVER can be used to connect only to a SQL Server DataSource.

ynvpavan

 Profile Answers by ynvpavan 

• Apr 18th, 2008

 

u just have a look over the fig 2 in this link and u can get somne info, i think...


http://msdn2.microsoft.com/en-us/magazine/cc163933.aspx


And also, the OLEDBSQL Provider posses native drivers to interact with database and the oledb had it's own drivers.
As compared, OLEDBsql driver is more efficient to use for the fastness.