what is the syntax code for oldb to connect oracle
Answers were Sorted based on User's Feedback
Answer / srinivas.kinthada
i think oldb is not correct it's may b.
it is oledb
using system.data.oledb;
oledbconnection cn=new
oledbconnection("uid=<username>;pwd=<password>;server=<servername>");
cn.open();
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raghavendra.v
it is not oldb it may be oledb
using System.Data.Oledb;
Oledbconnection cn=new OleDbConnection
("Provider=Msdaora.1;uid=<username>;pwd=<pwd>;server=<server
name>");
cn.open();
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sudha
first add the namespace
using system.Data.oledb;
OledbConnection cntn = new OledbConnection("Provider =
Microsoft.jet.oledb.12.0;datasource = (local);Integrated
security = SSPI,persistent Security = false");
provider = it depends on version of Microsoft Access like if
it is 2003 - 4.0 & if it is 2007 - 12.0
dataource - u can make it as local or provide the path to ur
database
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain executenonquery?
How to identify the controls which can be used for binding data?
Explain the differences between oledb sql server, oledbdotnet provider?
What does connection string consists of ?
What is ado net stands for?
What do you mean by performing asynchronous operation using command object?
What is the meaning of executenonquery?
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?
6 Answers Accenture, FastStream,
how can implement dropdownlist in particular of dataset when try to update?
What is the key feature of ADO.NET compared to ADO ?
What are the namespaces used in ado.net for data access?
What is ado.net code?
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)