Is it possible to call oracle database through ADO control
or Object?

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

DHTML Is used for what?

1496


how to use unicode data in vb6 regarding to telugu language, my output is in only telugu language

3203


How do I use GetPrivateProfileString to read from INI files?

1069


Difference between Tabletype and Snapshot?

1590


How would you add elements and pictures to listitems in listview control?

1618






What is dao in vb?

591


by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.

1772


What is executenonquery in vb net?

592


It is possible to access Text (x.txt) files? Explain.

1639


Is it posible to Create Tables Through Querydef?

1750


What are the different procedures associated with the object?

692


How do I call a DLL?

1134


What is ODBC Direct and Microsoft Jet Database Engine ?

1972


What is ODBC Direct and Microsoft Jet Database Engine ?

1565


To validate a range of values for a property whenever the property values changes,which type of property procedure you use?

1523