Connections to data sources using the IBM OLE DB Provider

The following examples show how to connect to a Db2® data source using the IBM® OLE DB Provider for Db2.

Example 1: Visual Basic application using ADO

Dim db As ADODB.Connection
Set db = New ADODB.Connection
db.Provider = "IBMDADB2"
db.CursorLocation = adUseClient
...

Example 2: C/C++ application using IDataInitialize and Service Component

hr = CoCreateInstance (
     CLSID_MSDAINITIALIZE, 
     NULL, 
     CLSCTX_INPROC_SERVER, 
     IID_IDataInitialize, 
     (void**)&pIDataInitialize);
	
hr = pIDataInitialize->CreateDBInstance(
     CLSID_IBMDADB2,	// ClassID of IBMDADB2
     NULL,
     CLSCTX_INPROC_SERVER,
     NULL,
     IID_IDBInitialize,
     (IUnknown**)&pIDBInitialize);