OleDB Connection

About Ole DB

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing different types of data stored in a uniform manner. It is a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. It was designed as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement SQL.

Connection

Comments

User fields

Creating New Ole DB connection

• In the Name Text Box type in a new name for the connection you are about to create
• Type in the connection string or use Build Connection String button to create one.
• Click OK to close the connection properties window

Ole DB is one of the slowest ways of accessing the data and it uses a lot of memory. It is not recommended for very large datasets.

List of Ole DB Drivers Download Links

Used by

1. OleDb Reader
2. OleDb Writer
3. Database Loop Action
4. Sql Script Action
5. Sql Data Check Action
6. Check Connection Action
7. SQL To Text Dynamic Action
8. SQL To XML Dynamic Action
9. SQL To Insert Dynamic Action
10. SQL To Excel Dynamic Action
11. SQL To QVD Dynamic Action
12. SQL To QVX Dynamic Action
13. Select Value Action
14. SQL Record to Variables Action
15. SQL to Variables Action