Answer Posted / subashini

yes,its possible.

First select the Microsoft ActiveX Data Objects 2.0 library
in References


Dim conn as New ADODB.Connection
Dim rs as New ADODB.Recorset

Private sub Form_Load()
conn.Open "Provider=MSDAORA.1;userid=scott;password=tiger;
persist security info=true"
conn.CursorLocation=adUseClient
End sub

What is form in visual basic?

533

---

When/Why should I use Option Explicit?

978

---

what is the Difference between Recordset and Querydef?

1865

---

Which method is used to write context Into file?

1576

---

Explain OLE Drag and Drop.

1508

---

---

how a multiple routing works ?

2307

---

Is it possible to Access BackEnd procedures?

1601

---

Can a VB application be an OLE server?

984

---

What are the scope of the class?

1549

---

What is the use of Scalewidth and ScaleHeight Proeperty?

1471

---

How can I access a record by record number?

1053

---

What is DAO?

1601

---

Difference between DDE and OLE.

2798

---

What is ODBC Direct and Microsoft Jet Database Engine ?

1874

---

How come I get a "No Current Record" error when I use a a Data Control on an empty table?

1063

---