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 do you mean by provider?

1 Answers  

---

How would you find out the value property in Slider Bar Control?

1 Answers  

---

Clear property is available in hich control?

2 Answers  

---

what is Type Library and what it's purpose?

1 Answers  

---

What type of databases you can access through AD I Data Access Object?

1 Answers  

---

---

Difference between Recordset and Resultsets.

0 Answers  

---

How would you map properties to controls by using ActiveX Control Interface Wizard?

0 Answers  

---

what are the Differences between ActiveX Exe and Dll?

2 Answers  

---

___ property is used to change to ___ value to access a identity column'in datacontrols.

0 Answers  

---

How the image application?

0 Answers  

---

Why is it not good to use a variant data type?

2 Answers  

---

What is the use of debug Window?

1 Answers  

---