Use ADO's native OLEDB drivers instead of ODBC

When you create an connection string, ADO gives you a choice between

 indicating a data source driver as either a Driver, as in:

Driver={SQL Server};DBQ=database_file

or a Provider, such as Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database_name

However, when you use the first option, ADO uses older ODBC driversto connect to the data source; whereas the second form uses OLEDB, which is ADO's native data access interface. For this reason, you should use the Provider option whenever possible. Such native OLEDB drivers exist for SQL Server, Index Server, Site Server Search, and Oracle, among others.

Active Server Index

Main Index