Kbase P86317: What technologies can be used to connect to Progress Database from Visual Basic?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
What technologies can be used to connect to Progress Database from Visual Basic?
GOAL:
What are ODBC, ADO, DAO, RDO or OLE-DB?
FIX:
The Progress SQL-92 ODBC driver allows tools and applications that support the
ODBC call library to use the Progress database as a data source. Progress does not care about the other side of ODBC. Any language, application and tools that supports ODBC call library can connect the database via ODBC.
ODBC provides a single API for client applications to work with different databases. The ODBC API can be considered as a low-level interface.
Higher level Microsoft database inferfaces include the following:
DAO - Data Access Objects (1-tier):
DAO is a set of (COM) Automation interfaces for the Microsoft Access/Jet database engine. DAO talks directly to Access/Jet databases. DAO can also communicate with other databases through the Jet engine. DAO provides an object model for database programming.
RDO - Remote Data Objects (2-tier):
RDO is easier to use than the ODBC API but doesn't offer the low-level control provided by the ODBC API. Because RDO calls the ODBC API directly (rather than through Jet like DAO), it can provide better performance.
OLE DB - Object-linking and embedding database:
OLE DB is Microsoft's successor to ODBC that utilizes a set of COM interfaces for accessing and manipulating of data. OLE DB provides an interface to both relational and nonrelational data sources.
ADO - ActiveX Data Objects (1 to n-tier):
ADO is a more recent Microsoft Data Access technology designed to replace DAO and RDO. ADO provides an object model for database programming that's similar to, but more flexible than DAO's object model. It is build on OLE DB technology.
For introduction to Visual Basic and database access, you can check
some samples available at www.vbexplorer.com (click for "Tutorials" and then "Database")