XOn Software
Industrial Ethernet mit LabVIEW

New dates 2017
more news ...

Code Review, System Design, individual training
more info...
Generate graphics and reports quickly with X1 2.3
more info...
Automate your tests with XGT 2.0.
more info...


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 © 2019 XOn Software GmbH

XOn, Products, Software, ADO