General discussion



By minakshi.batra ·
Dear All

I want to understand (specially difference of all above) 1) What is DSN, Why we make it?
2) Difference b/w these ADO/DAO/RDO/ODBC? Are these used for different database like ms access/oracle/sql server.
Please clarify. and pl. consider it urgent.
Thank you very much

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -


by john.a.wills In reply to VB-DSN-ADO-DAO-RDO-ODBC

stands for Visual Basic, which is a Microsoft database and form system with an associated language, VBA, VB for Applications, with which the designer can manipulate the input data.

Collapse -


by john.a.wills In reply to VB-DSN-ADO-DAO-RDO-ODBC

I do not know what this stands for, perhaps something database connection, but it is used toset up the connection between a front-end, e.g. an Access database, and a server database, e.g. SQL Server.

Collapse -

Two links for you (one of them also for john.a.wills)

by NickNielsen In reply to VB-DSN-ADO-DAO-RDO-ODBC

Acronym Finder - - Got an acronym, but don't know what it means? This is the site for you. For example, ODBC is short for Open Database connectivity.

FOLDOC (Free On-Line Dictionary of Computing) - - Defines common (and uncommon) computing terms. For example, ODBC is defined as follows:

Open DataBase Connectivity

<standard, database> (ODBC) A standard for accessing different database systems. There are interfaces for Visual Basic, Visual C++, SQL and the ODBC driver pack contains drivers for the Access, Paradox, dBase, Text, Excel and Btrieve databases.

An application can submit statements to ODBC using the ODBC flavor of SQL. ODBC then translates these to whatever flavor the database understands.

ODBC 1.0 was released in September 1992.

ODBC is based on Call-Level Interface and was defined by the SQL Access Group. Microsoft was one member of the group and was the first company to release a commercial product based on its work (under Microsoft Windows) but ODBC is not a Microsoft standard (as many people believe).

ODBC drivers and development tools are available now for Microsoft Windows, Unix, OS/2, and Macintosh.

Edit: close parentheses

Related Discussions

Related Forums