what is the syntax code for oldb to connect oracle?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the difference between readonly vs. Const?
Why do we use sqldataadapter?
What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?
Define different execute methods of ADO.NET command object ?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What are the two fundamental objects in ADO.NET?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
Being fresher How would i answer to the question that what is your salary exception?
How do you update a dataset in ado.net and how do you update database through dataset?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is data relation?
What are all the classes that are available in System.Data Namespace?