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

Explain the different row versions available in table?

1 Answers  


What is ODP.NET ?

1 Answers   TCS,


Features and disadvantages of dataset?

2 Answers   CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,


what is the criteria of selection in sbi interview?

1 Answers   BCS, State Bank Of India SBI,


What is datacolumn and how it is used?

2 Answers  


What is microsoft ole db provider for sql server?

1 Answers  


What is the default provider in ado.net?

1 Answers  


Difference between ADO and ADO.Net

4 Answers   IBM,


Which is the best institute in navi mumbai to learn DotNet

2 Answers  


How to read data with the sqldatareader ?

1 Answers  


What is the purpose of using adodb?

1 Answers  


What is difference between datagridview and datagrid control in winforms?

1 Answers  


Categories