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 does executereader return?

0 Answers  


Which is faster datareader or dataadapter?

0 Answers  


What is executescalar and executenonquery?

0 Answers  


What is meant by entity framework?

1 Answers  


Is entity framework better than ado.net?

0 Answers  






I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...

6 Answers  


What is microsoft ado.net?

0 Answers  


What is executequery?

0 Answers  


What are the Data providers in ADO.Net?

0 Answers  


What is row state?

0 Answers  


ADO and ADO.NET differences ?

2 Answers   Microsoft,


What are the essential features of ado.net?

0 Answers  


Categories