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 do you connect to sql server database without using sqlclient?
Define bubbled event?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
Which is better entity framework or ado.net?
Which object holds only data and does not interact with data source?
Is it possible to edit data in Repeater control?
What is csdl entity framework?
What does ado stand for in ado.net?
Which name space is used to get assembly details?
What is disconnected scenario in entity framework?
How to add an aggregate column?
Describe the command object and its method.
How to read data with the sqldatareader ?
What is oledb connection?
What is data access pattern?