Can anyone explain the use of OLE DB provider.
Is my understanding correctly?
When I use a OLE DB provider, e.g. the ole db provider for SQL server, the odbc driver will not be involved.
Thus the flow of the connection will like this:
ADO --> OLEDB provider for SQL server --> SQL Server...
(NO odbc driver will be involved?
Am I correct?
Furhter, the performance of this will be better than using the ODBC drvier?