Hi all

As all of you are aware,there are some DRIVERs for creating DataSources when
you want to build a new ODBC Connection.I want to know the difference between followings DRIVERs:

Microsoft OLE DB Provider For Sql Server
Microsoft OLE DB Provider For ODBC Drivers
SQL Native Client

What's the meaning of each one.? for example i think the first one connect to SQL Directly without interfering of any Middleware so it's faster than the second one.!! am i Rifgt? Please Guide me.


Also i have another question.is it possible to use BDE for connecting to Database BUT DIRECTLY.My friends say that
BDE By Default use some Middle ware to connect to DB so it's
Slow.is it true.?

Thanks In Advance.
Regards.

ZArrinPour,

The OLE DB Provider for ODBC allows you to use a single OLE DB provider to connect to multiple data sources (Oracle, SQL Server etc).

The OLEDB Provider for SQL Server is Microsoft's native SQL Server provider, used only to connect to SQL Server. This should be used instead of the OLE DB Provider for ODBC when connecting to SQL Server since the OLE DB Provider for ODBC provider entails more administrative overhead that the native OLE DB Provider for SQL Server.

SQL Native Client is the new data access technology new to SQL Server 2005. It is a stand-alone data access API that is used for both ODBC and OLE DB. It combines both the SQL Server OLE DB provider and the SQL ODBC driver into a single DLL, yet still providing new functionality over that which is found in MDAC. It also supports all the new features found in SQL Server 2005 such as the native XML data type.

Scott