Board index Database Programming

Diference between DAO, Jet Engine and ODBC

Diference between DAO, Jet Engine and ODBC

Post by Jeff Lundgre » Thu, 07 Aug 1997 04:00:00



DAO is native OLE to Access and ISAM databases like Paradox etc.
ODBC is the underlining API to databases.
Jet Engine is the database engine for MS Access databases.
RDO is a small wrapper around the ODBC API for remote databases (SQL
Server, Oracle etc.)
OLE DB is an OLE db interface that is new, mostly used in VC++, and is used
with ADO.
ADO is used for server side scripting with ASP, and others.

To many acronyms I know.
--
Jeff Lundgren

Remove the .nospam from the email address



>Can anyone tell me diference between DAO, Jet Engine and ODBC

>Thank's for the help
>--
>Lus Csar


 
 
 
Top

Diference between DAO, Jet Engine and ODBC

Post by Kevin R. Benedic » Fri, 08 Aug 1997 04:00:00


Quote:> ODBC is an industry-standard interface to client/server database
> systems.

> -- Jim Ferguson, FMS
>    http://www.fmsinc.com

ODBC is an industry standard to any ODBC compliant database engine,
client/server or not.

 
 
 
Top

Diference between DAO, Jet Engine and ODBC

Post by Jim Fergus » Fri, 08 Aug 1997 04:00:00


Luis,

Quote:>Can anyone tell me diference between DAO, Jet Engine and ODBC

The Jet engine is a fileserver database engine used by Access, VB,
VC++, VJ++ etc.

DAO is an automation interface to the Jet engine.

ODBC is an industry-standard interface to client/server database
systems.

-- Jim Ferguson, FMS
   http://www.fmsinc.com

 
 
 
Top

1. ODBC engine vs. Jet engine

Hi Pascal,

JET is the native data access engine of MS Access, while ODBC is
a standard interface to (almost) all Relational Databases such as
Oracle, SQL Server, DB2, etc. The differences of them lie in
the performance. To use ODBC to access Access data have a very
big over head for sure. That is why Microsoft developed a new technology
called OLEDB, which was designed as "unbiased" to any data providers.

So, to answer your question, neither ODBC nor JET are good solution,
instead, I recomend you to use OLEDB. In VB, that means to use
ADO (Active Data Object model).

ADO syntax is much near ADO. If you are familiar with JET/DAO,
use OLEDB/ADO is no difficult at all.

Hope this helps,

Tony


2. SQL in VB 4.0 Query Access 2.0 MDB

3. DAO & Jet Engine Licence

4. File format definition

5. Is there any BUG in DAO (Jet Engine) ??

6. ORDER BY within REPORT routine

7. DAO JET ENGINE ERROR

8. replication 6.5 7.0

9. Excel Access using DAO Jet Engine?

10. DAO/Jet engine redistributable files

11. "Unable to initialize DAO/Jet engine"

12. Microsoft Jet Engine and DAO (what are they..?)

13. DAO and Jet Engine


All times are UTC
Board index