what is the syntax code for oldb to connect oracle?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can provide data to ado.net?

540


Where is adodb dll located?

518


Which object of ado contains datarow datacolumn collection?

503


What is difference in record set and dataset?

525


What is ole access?

541






What are three methods for displaying data in a syncfusion datagrid

604


Which control of the BindingNavigator returns the current position within the data source?

723


What is the use of adodc?

519


What are the advantages of ado.net?

503


Is entity framework better than ado.net?

473


What is ole data type?

497


How to connect and retrieve data from database using dataset

527


What are the data access namespaces in .NET?

621


What is ado.net in vb net?

492


What connected data?

489