Export (0) Print
Expand All
3 out of 8 rated this helpful - Rate this topic

Programming OLE DB SQL Server Applications

SQL Server 2000

OLE DB is a low-level, COM API that is used for accessing data. OLE DB is recommended for developing tools, utilities, or low-level components that need high performance. The OLE DB Provider for SQL Server (SQLOLEDB) is a native, high performance provider that accesses the SQL Server TDS protocol directly.

SQLOLEDB exposes interfaces to consumers wanting access to data on one or more computers running an instance of Microsoft® SQL Server™ 2000 or SQL Server version 7.0 or earlier.

When developing an OLE DB consumer, select a provider developed for the data source to consume. Use SQLOLEDB to develop an optimized OLE DB consumer for SQL Server databases.

SQLOLEDB is an OLE DB version 2.0–compliant provider.

SQLOLEDB passes the command statements (such as SQL-92 and Transact-SQL) through to the server. The server rejects invalid commands.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.