XOn Software


Database with OLE-DB

ADODB ("ActiveX Data Objects Databases," abbreviated ADO) is the successor of DAO. DAO was actually designed only to be employed with Jet-Databases like Access or Excel. Other databases "must" be connected through ODBC which operates more laboriously and hence more slowly. ADO supports itself however on the OLEDB driver which the ODBC driver unhitches.

ADO Example 2 Get Tables

OLEDB offers more performance and often more possibilities for the developer. Over ADO, acccess to almost all commonly used databses is available-regardless as to whether or not it is Access, SQL-Server, Oracle, Informix and many more. ODBC connections allow themselves to be used hassle-free as well. However, they are actually superfluous through OLEDB.


  • Access to databases over the OLE-DB-Provider (MS-Access) is installed
  • OLE-DB-Provider native (quick!) for SQL-Server, Oracle, mySQL etc. available
  • "Compatible" with the "Database Connectivity Toolset" from NI. The underlying mechanism is the same, but our toolkit allows more substantial database manipulation.
Copyright © XOn Software GmbH

XOn, Produkte, Software, ADO