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 the use of adodc?

0 Answers  


What are the different row versions available in table?

0 Answers  


Explain the overview of ado.net architecture?

0 Answers  


What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,


What is ole in excel?

0 Answers  


What is Debug.write does?

1 Answers  


what is sql Injection?

4 Answers   Microsoft,


Can you edit data in the Repeater control?

9 Answers  


i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#.plz tell me code with an example.

5 Answers   Softcon, Tecra,


What is microsoft ole db provider for sql server?

0 Answers  


What are the Features and disadvantages of dataset

0 Answers   Microsoft,


Does ado.net use odbc?

0 Answers  


Categories