OLE DB Programming

Get flash to fully experience Pearltrees

Using the ATL OLE DB Consumer Templates on the Pocket PC - xfgr.com

Implementing a Simple Consumer (OLE DB Templates)

http://msdn.microsoft.com/en-us/library/53xey9th(v=vs.71).aspx

The following topics show how to edit the files created by the MFC Application Wizard and ATL OLE DB Consumer Wizard to create a simple consumer.

Before you open the rowset, you must tell the provider that you want to use bookmarks.

http://msdn.microsoft.com/en-us/library/az04c4tb(v=vs.80).aspx

Using Bookmarks (OLE DB Templates)

How To ExecuteParameterized Command Multiple Times with ATL OLEDB Consumer Templates

Executing a command multiple times is a very common scenario if the command is a parameterized query.

Introduction

Memory Leaks in ATL OLEDB Consumer Objects on CCommand

http://www.codeproject.com/Articles/35845/Memory-Leaks-in-ATL-OLEDB-Consumer-Objects-on-CCom

Asynchronous processing and multiple threads in OLEDB programming

Performing Asynchronous Operations

Applications designed to asynchronously open the result from the execution of a command can set the DBPROPVAL_ASYNCH_INITIALIZE bit in the DBPROP_ROWSET_ASYNCH property.

http://msdn.microsoft.com/en-us/library/windows/desktop/ms724368(v=vs.85).aspx

Asynchronous Processing (OLE DB)

Asynchronous processing enables methods to return immediately without blocking on the calling thread. Consumers request asynchronous processing when initializing a data source object or when opening or populating a rowset. The consumer must explicitly request asynchronous processing.

MySQL OLEDB Provider

Establishing the Connection

: VC++ 6.0, Service Pack 5 In my last article, I showed how to extend an OLE DB consumer template class and make it much easier to use in applications.

EXPRESS OLE DB Library for C++ - CodeGuru

http://www.codeguru.com/cpp/data/mfc_database/oledb/article.php/c4289/EXPRESS-OLE-DB-Library-for-C.htm

How To Insert NULL Data with OLE DB Consumer Templates

This article demonstrates how to use OLE DB consumer templates to insert NULL data into an SQL Server table by using a parameterized query. When you use the OLE DB consumer templates to insert NULL data, you must set the status of the input parameter to DBSTATUS_S_ISNULL. This sends the NULL value to the provider, and lets the provider ignore the contents of the value and length portions of the consumer buffer.