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 is difference between connected and disconnected architecture in ado.net?

0 Answers  


How can we serialize the dataset object?

0 Answers  


What are the benefits of using of ADO.NET in .NET 4.0?

0 Answers  


Why is ADO.NET serialization slower than ADO ?

0 Answers   NA,


What is the difference between oledbreader and datasetwhile connecting?

1 Answers  






What connected data?

0 Answers  


What is ado asp?

0 Answers  


Which ado.net object is very fast in getting data from the database?

0 Answers  


Where do you store connection string ?

3 Answers   Digital GlobalSoft,


Which is faster dataset or datareader?

0 Answers  


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

0 Answers  


What is two way data binding android?

0 Answers  


Categories