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 the default view of Data Grid?
What is ado rdo dao in visual basic?
What is shadow copy?
What is dataset and datatable in ado.net?
Which are the different IsolationLevels ?
What is row state?
What is data relation in ado.net?
ADO and ADO.NET differences ?
Why sql Data Reader object not created
How many major types of connection objects in ADO.NET?
How to retrieve the user id which is provided while windows authentication?
What is the DataTableCollection?
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)