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

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

Question Posted / swapna

4 Answers
5934 Views
Microsoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / naresh

The provider name is oledb and the namespaceis
system.data.oledb

Is This Answer Correct ?

3 Yes

1 No

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

Answer / parveen atreya

The Most app. provider is OracleClient. To use this
provider we have to add this from add reference utilities
in dot net application. The Namespace for this is ....

SQL.DATA.OracleClient

enjoy..........

Is This Answer Correct ?

3 Yes

1 No

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

Answer / 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

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

Answer / surendra

oledb Provider -->system.data.oledb;
odbc -->no namespace;
oracle -->system.data.oracleclient;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

Why DataReader is Forward Only?