OLE DB Programming

TwitterFacebook
Get flash to fully experience Pearltrees

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

http://support.microsoft.com/kb/240412 Executing a command multiple times is a very common scenario if the command is a parameterized query.
http://msdn.microsoft.com/en-us/library/ms131395.aspx

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

http://support.microsoft.com/kb/260900 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.
Consumers use several kinds of objects, which are described in the following topics: Before the consumer does anything, you first select an OLE DB provider that is appropriate for the type of database you need to access (for example, SQL, Oracle, ODBC, and MSDS).

OLE DB Consumer Templates (C++)

http://msdn.microsoft.com/en-us/library/fk4h509a.aspx

ATL OLE DB Consumer Template Schemas

http://www.codeproject.com/script/common/404.aspx?aspxerrorpath=/KB/windows/sqlcespy.aspx Page Not Found Unfortunately the page you requested was not found. The following is the most likely location