OLE-DB connector
- Last UpdatedFeb 24, 2025
- 1 minute read
The OLE DB connector library provides connection to and data retrieval from OLE DB providers such as an Oracle database, Microsoft Access database, Microsoft SQL Server, and DB2 database. OLE DB provides uniform access to unstructured data regardless of type or location on the network.
Elements
The OLE DB connector library contains the following items:
-
Data source
-
Data connection
-
Variable
-
Adapter
OLE-DB connector guidelines
-
You can add multiple data sources to an project.
-
You can add only one data connection to a data source.
-
You can add any number of variables and adapters to a data source.
-
A variable contains an SQL Select query statement.
-
An adapter contains SQL Select, Insert, Update, and Delete query statements.
Related topics
In This Topic
Related Links
- Add and configure an OLE-DB data source
- OLE-DB data source properties
- Add and configure an OLE-DB data connection
- OLE-DB data connection properties
- Understand OLE-DB security settings and remote connections
- Add and configure an OLE-DB variable
- OLE-DB variable properties
- About the OLE-DB adapter
- Add and configure an OLE-DB adapter
- Using parameters in OLE-DB adapter
- OLE-DB connector adapter properties
- Add OLE-DB parameters
- List of OLE-DB parameter properties
- Execute Build Update commands
- Test adapter with Execute Query
- About the OLE-DB connection string
- Create a .udl file of a connection string