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();

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();

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

What are the key events of sqlconnection class?

0 Answers  

---

What are typed and untyped dataset?

0 Answers  

---

Can datareader hold data from multiple tables?

0 Answers  

---

What are the major difference between classic ADO and ADO.NET?

0 Answers  

---

Define ado.net?

0 Answers  

---

---

can we execute trigger normally at the desired time?

3 Answers   Microsoft,

---

What is a dynaset in access?

0 Answers  

---

When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency

4 Answers   Digital Group,

---

What is oledb driver?

0 Answers  

---

Features and disadvantages of dataset?

2 Answers   CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,

---

What is the difference between Data adaptor and Data set?

0 Answers   HCL,

---

Explain what a diffgram is and its usage ?

2 Answers  

---