Answer / 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 ado data control in vb6 0?

0 Answers  

---

How do I create a new form in visual basic?

0 Answers  

---

Is there any Edit method in ADO Data Access method?

3 Answers  

---

How do I create controls dynamically (at run-time)?

0 Answers  

---

What are the Sequence of events when a form is loaded in Visual Basic?

6 Answers  

---

What are the rules which should be followed while naming a variable in VB?

0 Answers  

---

What is the use of debug Window?

0 Answers  

---

Is there any way to pass a variable to a form apart from using global variables?

0 Answers  

---

How do I get the Tab key to be treated like a normal character?

0 Answers  

---

What are the Style Properties of Combo Box?

2 Answers  

---

Scope of API's can be of types, what are they?

0 Answers  

---

What will happen if you issue a Resume statement after handling an error?

3 Answers  

---