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 Different layers in ADO.Net?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What is an example of ordinal data?
Explain ado.net features?
What is a serialized object?
How many types of data table are in SQL.NET
4 Answers Chetu India, HCL, MAHINDRA,
What are the steps in connecting to database?
What is ole db and odbc?
How we can provide data to ado.net?
What are the advantages of using datalist?
What is the difference between connected and disconnected environment?
Describe briefly an ADO.NET Dataset ?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)