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
What is ole2 format?
Does ado.net use odbc?
Can datareader hold data from multiple tables?
What are the different ado.net namespaces?
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
What is ambient transaction?
What is executequery?
What are the essential features of ado.net?
What is difference between datagridview and datagrid control in winforms?
What is ole db and odbc?
What is dataset object? Explain the various objects in dataset.
What is the difference between the clone() and copy() methods of the dataset class?
What are basic methods of dataadapter?
What is ado.net full form?
What is sql command in ado net?