Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

How would you connect to database using .NET?

0 Answers  


what is the syntax code to oledb to connect oracle

6 Answers   IBM,


What is connection in ado.net?

0 Answers  


Which is better ole db or odbc?

0 Answers  


What is namespace in ado.net?

0 Answers  






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

2 Answers  


What is the difference between sqldatareader and sqldataadapter?

0 Answers  


Can I use One Data Set for More than one Data Adapter?

6 Answers  


Explain the difference between ado and ado.net?

0 Answers  


What is the difference between Data adaptor and Data set?

0 Answers   HCL,


What are all the commands used with Data Adapter?

0 Answers  


describe about the ado.net object model

4 Answers   TCS,






Categories