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
How we can provide data to ado.net?
Where is adodb dll located?
Which object of ado contains datarow datacolumn collection?
What is difference in record set and dataset?
What is ole access?
What are three methods for displaying data in a syncfusion datagrid
Which control of the BindingNavigator returns the current position within the data source?
What is the use of adodc?
What are the advantages of ado.net?
Is entity framework better than ado.net?
What is ole data type?
How to connect and retrieve data from database using dataset
What are the data access namespaces in .NET?
What is ado.net in vb net?
What connected data?