When you access an OLE DB data provider in DataWindow Designer, your connection goes through several layers before reaching the data provider. It is important to understand that each layer represents a separate component of the connection, and that each component might come from a different vendor.
Because OLE DB is a standard API, DataWindow Designer uses the same interface to access every OLE DB data provider. As long as an OLE DB data provider supports the object interfaces required by DataWindow Designer, DataWindow Designer can access it through the OLE DB interface.
Figure 3-1 shows the general components of a OLE DB connection.
Figure 3-1: Components of an OLE DB connection
