Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-01 : 11:04:10
|
Sashi writes "For SQL Server, two types of OLE DB providers can be used:
1. Microsoft OLE DB Provider for SQL Server (SQLOLEDB).
2. Microsoft OLE DB Provider for ODBC (MSDASQL).
We can access SQL server from client application (e.g. VBA) thru any of these provider with ADO consumer.
I would be like know, which provider will give us best efficiency and performance.
I would appreciate, if you could provide brief details.
Thanks you very much.
-Sashi." |
|
|
|
|
|
OLE DB Providers