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
Which property is used to check whether a DataReader is closed or opened?
What are the major challenges in accessing data from a database?
What is a sqldataadapter?
What is the role of data provider in ado.net?
What is disconnected scenario in entity framework?
Is bulk insert faster than insert?
What is difference in record set and dataset?
What is the difference between data grid and data repeater?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
What is difference between ado and other data object?
What do you know about ado.net's methods?
What is Dataset Object?
How to add a javaScript function in a datagrid?
What is the namespaces being used to access oracle database?
describe the dataset object in ado.net.