OLE DB

OLE (object linking and embedding) is a specification that defines ways in which different applications can make data available to each other. OLE DB is OLE applied to databases. Using OLE DB providers, an application can work with data from a variety of databases.

Microsoft supplies OLE DB providers for many data sources, including SQL Server, Oracle, Jet (Access databases), AS/400, and VSAM. It also has an ODBC provider that gives access to ODBC-compliant databases, which includes most relational databases.

Visual Basic provides a family of objects that work with OLE DB data providers. Table 6.6 summarizes those objects.

Table 6.6. OLE DB Data Access Objects
Class Purpose
OleDbConnection Connects the application to a database using ...

Get Visual Basic® .NET Database Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.