Hi

1)please tell me what is odbc ? why it is required ?

2) Differentiate between ADO,DAO,RDO, and which should i use for oracle vb connectivity for handling large database efficiently ?

3) what is oledb ?

4) what is dsn less and dsn connetion ?
   which of them is better ?

5) what is oledb ?


 ok BYE PLEASE HELP ME .

ODBC - Open Database Connectivity
It is a set of API Function that is required to connect to Databases that uses Structured Querying Language(SQL).

ADO - ActiveX Data Objects. It is a set Clasess and Objects bases on COM Technology that can connect to any SQL and non-SQL Based databases(like Excel, XML, CSV files also)

ADO is the best and performance oriented way for connecting database
DAO and RDO are nearly Obsolete

OLEDB is a set of Providers that helps us to connect to SQL and non SQL Based databases. ADO Uses OLE-DB Providers to connect to the database

Hope this info would help u.

Regards,
Raghu

Is ADO proven to be faster performance wise than DAO when accessing an Oracle DB?

The performance difference is small, and one technology is a little better at this, the other a little better at that, and so on.

ADO is the technology that Microsoft seems to be sticking with, since there is now ADO.NET out. Best to stick with technology that has at least a little life expectancy...