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 is ado data control?
How many major types of connection objects in ADO.NET?
What is shadow copy?
Explain the overview of ado.net architecture?
How to you declare connection strings and how to you make use of web.config ?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
differance between ADO vs ADO.Net?
What is reference by value how does it works in .net?
What is oledb connection?
What is openrowset?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is defaultview in datatable?
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)