what is the syntax code for oldb to connect oracle?

Answers were Sorted based on User's Feedback



what is the syntax code for oldb to connect oracle?..

Answer / srinivas.kinthada

i think it's oledb may b.

in c#.net coding

1)
using oledd provider
1.system.data.oledb;
2.oledbconnection cn=new
oledbconnection("username=<username>;pwd=<password>;server=<servername>");
3.cn.open();

2)
using orcale provider
1.first u can give in u r application reference of
system.data.orcaleclient.dll file trough solutionexplorer of
u r application
(rt click the mouse--->over solutinexplorer--->and click add
reference--->click on project---> and select
system.data.orcaleclient.dll file--->ok )
2.using system.data.orcaleclient;
3.orcaleconnection cn=new
orcaleconnection("username=<username>;pwd=<password>;server=<servername>");
3.cn.open();

Is This Answer Correct ?    1 Yes 0 No

what is the syntax code for oldb to connect oracle?..

Answer / ranjeet kumar panda

OledbConnection cn=new
OledbConnection
("Provider=msdaora;username=<username>;pwd=<password>;Data
Source=<servername>");

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

What are the difference between readonly vs. Const?

0 Answers  


Why do we use sqldataadapter?

0 Answers  


What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 Answers  


Define different execute methods of ADO.NET command object ?

0 Answers   NA,


What is the difference between an ADO.NET Dataset and an ADO Recordset?

0 Answers  


What are the two fundamental objects in ADO.NET?

8 Answers   Ksb, TCS,


what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

0 Answers   EDS,


Being fresher How would i answer to the question that what is your salary exception?

4 Answers  


How do you update a dataset in ado.net and how do you update database through dataset?

0 Answers  


What two types of data providers does ADO.NET supply? What determines which one you should use?

0 Answers   CDC,


What is data relation?

0 Answers  


What are all the classes that are available in System.Data Namespace?

0 Answers  


Categories