What are the different controls in VB . What is the difference between ADO and DAO . Which one is efficient?
-
-
Hi...........
DAO can access most local databases, and remote databases (actually through
ODBCDirect which uses RDO). There are performance issues with connecting
remotely though.
RDO will conect remotely to most any dataource, but it doesn't handle local
databases well, performance wise. It is an easy interface to the MS ODBC API
(Application Programming Interface)
ADO is the newest technology, it is simpler and more efficient in resources
than the above. It will access local and remote databases, as well as
files, and email programs like Exchange.. It is also used in ASP. It is
what Miscrosoft recommend using, now.
Using ADO Objects :
ADO has three objects, the Connection, the Recordset, and the Command
object.
Command is not normally needed. To proceed from here, look up "ADO
Connection" then look up "ADO Recordset", to connect and retrieve records
from a data source.
You can also use the ADOData control and bound controls, to make simple apps
without code. There is the Data Environment, too, which basically tries to
do the same as the ADOData control i.e. making simple database apps with
little or no code.
Comment