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
Why edit is not possible in repeater?
What is disconnected data?
What are the advantages using ado.net?
What is a sqldataadapter?
Explain what is datagrid with an example?
What is dataset object? Explain the various objects in dataset.
Give an example that shows how to execute a stored procedure in ado.net?
How to identify the updated rows in a dataset?
What is a datareader object?
What is the current version of entity framework?
What are the core objects of ADO.NET?
What is aggregating data ?
Why is it important to close an ado.net application?
What is the difference between Command and CommandBuilder object?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!