What is the provider and namespaces being used to access
oracle database?

Answer Posted / naresh

We can use any of the following providers to connect to the
oracle databas

Oledb provider
Odbc provider
OracleClient Provider

and the namespaces for the above provider are

Oledb provider--> System.Data.Oledb
Odbc provider---> System.Data.Odbc
OracleClientProvider--> System.Data.OracleClient

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create dynamic gridview?

795


Explain what is datagrid with an example?

821


What are the namespaces used in ado.net for data access?

686


What is ado object model?

699


What is difference in record set and dataset?

737


What are all the commands used with Data Adapter?

728


What are the different execute methods of Ado.Net?

739


What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

783


What are the major difference between classic ADO and ADO.NET?

733


What are all the different methods under sqlcommand?

707


What connected data?

691


What are the ado.net objects?

695


How to store data in memory?

694


What is the role of clr?

722


How to check if the Dataset has records ?

735